Tweet Engagement Over Time

\n setSelectedTweetId(e.target.value)}\n style={{ width: \"100%\", marginBottom: \"20px\", padding: \"10px\" }}\n >\n {tweets.map(tweet => (\n \n ))}\n \n \n Ver tweet {selectedTweetId} en Twitter\n \n \n \n \n new Date(value).toLocaleString()}\n />\n \n \n \n new Date(value).toLocaleString()}\n />\n \n \n \n \n \n \n

\n notamos picos de interacciones de bots en varios tweets de Milei a lo largo de los meses. por ejemplo, hace unos\n meses, el tweet de Milei que fue ratio-eado por Adornibord fue{\" \"}\n inflado de likes y retweets{\" \"}\n de bots, que pudimos medir ya que los username de los bots seguían un patrón. (en ese caso, se intentó ajudicar\n los bots a \"los hagoveros\" mandando los mismos bots al tweet de Adornibord, pero pudimos comprobar que los bots\n fueron primero al bot de Milei, y luego al tweet de Adornibord después de que las acusaciones por bots hayan\n empezado)\n

\n esta es la última ocurriencia que detectamos de este fenómeno: en este caso, Milei es \"domado\" por Rebord al\n caer en un clip de su programa en los que se hacen los \"kukas indignados\" intencionalmente. Milei cae por este\n \"bait\", y lo retweetea con su texto.\n

\n en este caso, y al ya no poder ver los usuarios que likearon el tweet (ya que Elon ocultó los likes de todo el\n mundo), usamos otro método: ver a lo largo del tiempo como aumenta bruscamente la cantidad de likes,\n disproporcionalmente a la cantidad de views, y luego como va decayendo a lo largo de que Twitter va eliminando\n las cuentas bots.\n

\n ver código fuente\n ⋅\n @esoesnulo\n ⋅\n nulo.in\n

\n );\n}\n\nfunction client() {\n const tweetData = JSON.parse(document.getElementById(\"tweet-data\").textContent);\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n\n const tweets = await sqlite.execute(`\n SELECT\n id, \n time,\n json_extract(json, '$.favorite_count') as favorite_count,\n json_extract(json, '$.retweet_count') as retweet_count,\n json_extract(json, '$.views_count') as views_count,\n json_extract(json, '$.full_text') as text\n FROM tweets_archive \n ORDER BY time ASC\n `);\n\n const tweetData = tweets.rows.map(tweet => ({\n id: tweet.id,\n time: tweet.time * 1000, // Convert to milliseconds\n favoriteCount: parseInt(tweet.favorite_count) || 0,\n retweetCount: parseInt(tweet.retweet_count) || 0,\n viewsCount: parseInt(tweet.views_count) || 0,\n text: tweet.text || \"\",\n }));\n\n return new Response(\n `\n \n \n Tweet Engagement Over Time\n \n \n \n

\n \n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n },\n );\n}\n\nconst css = `\nbody {\n margin: 0;\n font-family: system-ui, sans-serif;\n display: flex;\n justify-content: center;\n align-items: center;\n min-height: 100vh;\n background-color: #f0f0f0;\n padding: 20px;\n}\nselect {\n font-size: 16px;\n}\n`;","nulo-mileishowgraph",[],[99],"files",[152,172],"counts",{"_185":32,"_186":160,"_187":188,"_189":32},"pulls","branches","forks",3,"envVars","contents",[],{"_104":173,"_95":99,"_155":117,"_157":-5,"_158":140,"_159":101,"_161":22,"_106":193,"_100":175,"_163":176,"_165":177,"_167":22,"_168":178,"_98":194},["D",1733868561045],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":43,"_100":101,"_98":99,"_102":203,"_150":208,"_181":215,"_164":216,"_190":218,"_219":-5,"_220":22,"_221":-5,"_222":-5,"_223":-5,"_224":225},{"_104":105,"_95":96,"_106":204,"_108":-5,"_109":110,"_111":112,"_113":-5,"_114":-5,"_14":115,"_116":117,"_118":110,"_119":-5,"_120":32,"_16":121,"_122":123,"_124":123,"_125":126,"_127":126,"_128":126,"_129":123,"_130":123,"_23":205,"_134":206,"_137":207,"_149":22},["D",1745425873025],{"_93":94,"_132":133},{"_93":94,"_136":133},{"_100":139,"_95":43,"_104":140,"_141":105,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":96,"_148":94},[209,212],{"_104":153,"_95":154,"_155":156,"_157":-5,"_158":140,"_159":160,"_161":110,"_106":162,"_100":32,"_163":164,"_165":166,"_167":22,"_168":-5,"_169":210,"_98":211},[],[154],{"_104":173,"_95":99,"_155":117,"_157":-5,"_158":140,"_159":101,"_161":22,"_106":174,"_100":175,"_163":176,"_165":177,"_167":22,"_168":178,"_169":213,"_98":214},[],[99],[209,212],{"_104":173,"_95":99,"_155":117,"_157":-5,"_158":140,"_159":101,"_161":22,"_106":193,"_100":175,"_163":176,"_165":177,"_167":22,"_168":178,"_98":217},[99],[],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]

nulo

mileiShowGraph