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 FROM tweets_archive \n where time < 1733809006\n ORDER BY time ASC\n \n `);\n\n const tweetsWithText = await sqlite.execute(`\n select distinct id, json_extract(json, '$.full_text') as text from tweets_archive`);\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: tweetsWithText.rows.find(t => t.id === tweet.id)!.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`;","createdAt",["D",1738862097835],"version",87,"currentUserHasLiked","likeCount","forkCount",4,"referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_131":132,"_133":134},"handle","nulo","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yb0xkWWZwMG1qbGFWeXFWVjNjZFBhY0tzV2QifQ","forkedVal","interval","slug","nulo/mileiShowGraph","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[143,146,150,154,158,162,166,170,174,178,182,186,190,194,199,203,207,211,215,219,223,227,231,235,239,243,247,251,255,259,263,267,271,275,279,283,287,291,295,299,303,307,311,315,319,323,327,331,335,339,343,347,351,355,359,363,367,371,375,379,383,387,391,395,399,403,407,411,415,419,423,427,431,435,439,443,447,451,455,459,463,467,471,475,478,482,485,488],{"_118":119,"_144":-5,"_116":145,"_113":111},"prId",["D",1738862097835],{"_118":147,"_144":-5,"_116":148,"_113":149},86,["D",1738862097665],"e3f7c058-e4ad-11ef-be96-e6cdfca9ef9f",{"_118":151,"_144":-5,"_116":152,"_113":153},85,["D",1738859939837],"ddcb14f0-e4a8-11ef-aeb0-e6cdfca9ef9f",{"_118":155,"_144":-5,"_116":156,"_113":157},84,["D",1738859802053],"8bac0e72-e4a8-11ef-9fe9-e6cdfca9ef9f",{"_118":159,"_144":-5,"_116":160,"_113":161},83,["D",1738859757735],"714226a2-e4a8-11ef-8a8a-e6cdfca9ef9f",{"_118":163,"_144":-5,"_116":164,"_113":165},82,["D",1738859752271],"6e01112e-e4a8-11ef-89ab-e6cdfca9ef9f",{"_118":167,"_144":-5,"_116":168,"_113":169},81,["D",1738859610191],"1955d3da-e4a8-11ef-84bf-e6cdfca9ef9f",{"_118":171,"_144":-5,"_116":172,"_113":173},80,["D",1738859480425],"cbf86c56-e4a7-11ef-869c-e6cdfca9ef9f",{"_118":175,"_144":-5,"_116":176,"_113":177},79,["D",1738859475171],"c8d4909a-e4a7-11ef-9ea1-e6cdfca9ef9f",{"_118":179,"_144":-5,"_116":180,"_113":181},78,["D",1738859435944],"b174b1a0-e4a7-11ef-bb61-e6cdfca9ef9f",{"_118":183,"_144":-5,"_116":184,"_113":185},77,["D",1738859289645],"5a3fccda-e4a7-11ef-9fc3-e6cdfca9ef9f",{"_118":187,"_144":-5,"_116":188,"_113":189},76,["D",1738859276122],"52316ce2-e4a7-11ef-896f-e6cdfca9ef9f",{"_118":191,"_144":-5,"_116":192,"_113":193},75,["D",1738859192454],"205226d0-e4a7-11ef-9b1d-e6cdfca9ef9f",{"_118":195,"_144":196,"_116":197,"_113":198},74,"f64cfcb8-d4e6-11ef-a8bc-e6cdfca9ef9f",["D",1737155888238],"4fe2df58-d529-11ef-9e26-e6cdfca9ef9f",{"_118":200,"_144":-5,"_116":201,"_113":202},73,["D",1736960922808],"5f708154-d363-11ef-8c64-e6cdfca9ef9f",{"_118":204,"_144":-5,"_116":205,"_113":206},72,["D",1733868802919],"f85cf19a-b743-11ef-9307-e6cdfca9ef9f",{"_118":208,"_144":-5,"_116":209,"_113":210},71,["D",1733868724025],"c9562d12-b743-11ef-b8d2-e6cdfca9ef9f",{"_118":212,"_144":-5,"_116":213,"_113":214},70,["D",1733868701253],"bbc42e1a-b743-11ef-9d9b-e6cdfca9ef9f",{"_118":216,"_144":-5,"_116":217,"_113":218},69,["D",1733868611302],"8626ceb6-b743-11ef-9b8e-e6cdfca9ef9f",{"_118":220,"_144":-5,"_116":221,"_113":222},68,["D",1733868561045],"6831f7d2-b743-11ef-90fa-e6cdfca9ef9f",{"_118":224,"_144":-5,"_116":225,"_113":226},67,["D",1731036187438],"c5f7c86a-9d80-11ef-bb34-de64eea55b61",{"_118":228,"_144":-5,"_116":229,"_113":230},66,["D",1731036070176],"801314e4-9d80-11ef-bc10-de64eea55b61",{"_118":232,"_144":-5,"_116":233,"_113":234},65,["D",1731036060667],"7a686698-9d80-11ef-90e0-de64eea55b61",{"_118":236,"_144":-5,"_116":237,"_113":238},64,["D",1731036005275],"5963a912-9d80-11ef-9967-de64eea55b61",{"_118":240,"_144":-5,"_116":241,"_113":242},63,["D",1731035993814],"528f0334-9d80-11ef-b4cc-de64eea55b61",{"_118":244,"_144":-5,"_116":245,"_113":246},62,["D",1731035843772],"f9209f2e-9d7f-11ef-8ad5-de64eea55b61",{"_118":248,"_144":-5,"_116":249,"_113":250},61,["D",1731035806322],"e2cdde6c-9d7f-11ef-96e6-de64eea55b61",{"_118":252,"_144":-5,"_116":253,"_113":254},60,["D",1731035795085],"dc1b958c-9d7f-11ef-84ab-de64eea55b61",{"_118":256,"_144":-5,"_116":257,"_113":258},59,["D",1731035615800],"713eb974-9d7f-11ef-af66-de64eea55b61",{"_118":260,"_144":-5,"_116":261,"_113":262},58,["D",1731035586749],"5fee2628-9d7f-11ef-94c0-de64eea55b61",{"_118":264,"_144":-5,"_116":265,"_113":266},57,["D",1731035568170],"54db6a7a-9d7f-11ef-896d-de64eea55b61",{"_118":268,"_144":-5,"_116":269,"_113":270},56,["D",1731035567677],"54912a8c-9d7f-11ef-9e3d-de64eea55b61",{"_118":272,"_144":-5,"_116":273,"_113":274},55,["D",1730913107235],"34733380-9c62-11ef-8ace-de64eea55b61",{"_118":276,"_144":-5,"_116":277,"_113":278},54,["D",1730913084405],"26d8a3fe-9c62-11ef-833f-de64eea55b61",{"_118":280,"_144":-5,"_116":281,"_113":282},53,["D",1730913082527],"25b94b18-9c62-11ef-9b02-de64eea55b61",{"_118":284,"_144":-5,"_116":285,"_113":286},52,["D",1730913039380],"0c017d94-9c62-11ef-96c3-de64eea55b61",{"_118":288,"_144":-5,"_116":289,"_113":290},51,["D",1730913017578],"ff02bcca-9c61-11ef-8b78-de64eea55b61",{"_118":292,"_144":-5,"_116":293,"_113":294},50,["D",1730912990084],"eea015f8-9c61-11ef-a0b3-de64eea55b61",{"_118":296,"_144":-5,"_116":297,"_113":298},49,["D",1730912982434],"ea100a48-9c61-11ef-b0e8-de64eea55b61",{"_118":300,"_144":-5,"_116":301,"_113":302},48,["D",1730912804137],"7fca295c-9c61-11ef-8823-de64eea55b61",{"_118":304,"_144":-5,"_116":305,"_113":306},47,["D",1730912751706],"6089e3d4-9c61-11ef-93c1-de64eea55b61",{"_118":308,"_144":-5,"_116":309,"_113":310},46,["D",1730912596686],"04246998-9c61-11ef-8a29-de64eea55b61",{"_118":312,"_144":-5,"_116":313,"_113":314},45,["D",1730912586138],"fdda2190-9c60-11ef-8c4d-de64eea55b61",{"_118":316,"_144":-5,"_116":317,"_113":318},44,["D",1730912529906],"dc565606-9c60-11ef-b1e4-de64eea55b61",{"_118":320,"_144":-5,"_116":321,"_113":322},43,["D",1730912386185],"86ac72da-9c60-11ef-bf74-de64eea55b61",{"_118":324,"_144":-5,"_116":325,"_113":326},42,["D",1730912346435],"6ef9f4aa-9c60-11ef-bd0d-de64eea55b61",{"_118":328,"_144":-5,"_116":329,"_113":330},41,["D",1730912205611],"1b0a6460-9c60-11ef-9eaf-de64eea55b61",{"_118":332,"_144":-5,"_116":333,"_113":334},40,["D",1730912111868],"e32a2fa8-9c5f-11ef-91d3-de64eea55b61",{"_118":336,"_144":-5,"_116":337,"_113":338},39,["D",1730912059290],"c3d47500-9c5f-11ef-921e-de64eea55b61",{"_118":340,"_144":-5,"_116":341,"_113":342},38,["D",1730912017149],"aab58f28-9c5f-11ef-a436-de64eea55b61",{"_118":344,"_144":-5,"_116":345,"_113":346},37,["D",1730912003783],"a2be0278-9c5f-11ef-aec1-de64eea55b61",{"_118":348,"_144":-5,"_116":349,"_113":350},36,["D",1730911894523],"619e8e20-9c5f-11ef-aec1-de64eea55b61",{"_118":352,"_144":-5,"_116":353,"_113":354},35,["D",1730911767031],"159fe9d8-9c5f-11ef-8e8f-de64eea55b61",{"_118":356,"_144":-5,"_116":357,"_113":358},34,["D",1730911692043],"e8ed9c1e-9c5e-11ef-9433-de64eea55b61",{"_118":360,"_144":-5,"_116":361,"_113":362},33,["D",1730909964964],"e3827b0e-9c5a-11ef-b0cd-de64eea55b61",{"_118":364,"_144":-5,"_116":365,"_113":366},32,["D",1730906836429],"9ac21610-9c53-11ef-9aa4-de64eea55b61",{"_118":368,"_144":-5,"_116":369,"_113":370},31,["D",1730906629824],"1f9d0922-9c53-11ef-9ad7-de64eea55b61",{"_118":372,"_144":-5,"_116":373,"_113":374},30,["D",1730906628812],"1f01b3e6-9c53-11ef-baed-de64eea55b61",{"_118":376,"_144":-5,"_116":377,"_113":378},29,["D",1730906532512],"e59dbc9e-9c52-11ef-9190-de64eea55b61",{"_118":380,"_144":-5,"_116":381,"_113":382},28,["D",1730906532359],"e584d72e-9c52-11ef-a014-de64eea55b61",{"_118":384,"_144":-5,"_116":385,"_113":386},27,["D",1730906477197],"c4a32718-9c52-11ef-8b19-de64eea55b61",{"_118":388,"_144":-5,"_116":389,"_113":390},26,["D",1730906477042],"c48c778e-9c52-11ef-b049-de64eea55b61",{"_118":392,"_144":-5,"_116":393,"_113":394},25,["D",1730906438306],"ad75dd24-9c52-11ef-bf8c-de64eea55b61",{"_118":396,"_144":-5,"_116":397,"_113":398},24,["D",1730906418337],"a1903900-9c52-11ef-b0d0-de64eea55b61",{"_118":400,"_144":-5,"_116":401,"_113":402},23,["D",1730906393763],"92e8b17a-9c52-11ef-9190-de64eea55b61",{"_118":404,"_144":-5,"_116":405,"_113":406},22,["D",1730906393684],"92dc6082-9c52-11ef-9aa4-de64eea55b61",{"_118":408,"_144":-5,"_116":409,"_113":410},21,["D",1730906391763],"91b78754-9c52-11ef-b4d2-de64eea55b61",{"_118":412,"_144":-5,"_116":413,"_113":414},20,["D",1730906365649],"8226f57c-9c52-11ef-91ea-de64eea55b61",{"_118":416,"_144":-5,"_116":417,"_113":418},19,["D",1730906335750],"70543d5a-9c52-11ef-9f1f-de64eea55b61",{"_118":420,"_144":-5,"_116":421,"_113":422},18,["D",1730906214232],"27e61994-9c52-11ef-b2e3-de64eea55b61",{"_118":424,"_144":-5,"_116":425,"_113":426},17,["D",1730906213575],"2783a854-9c52-11ef-80cd-de64eea55b61",{"_118":428,"_144":-5,"_116":429,"_113":430},16,["D",1730906213341],"275f4392-9c52-11ef-b7a8-de64eea55b61",{"_118":432,"_144":-5,"_116":433,"_113":434},15,["D",1730905826269],"40a7f9bc-9c51-11ef-aa99-de64eea55b61",{"_118":436,"_144":-5,"_116":437,"_113":438},14,["D",1730905750010],"133381b8-9c51-11ef-977b-de64eea55b61",{"_118":440,"_144":-5,"_116":441,"_113":442},13,["D",1730904853926],"fd18f57c-9c4e-11ef-a66f-de64eea55b61",{"_118":444,"_144":-5,"_116":445,"_113":446},12,["D",1730904752398],"c094211c-9c4e-11ef-8ba3-de64eea55b61",{"_118":448,"_144":-5,"_116":449,"_113":450},11,["D",1730904751889],"c0468330-9c4e-11ef-99e6-de64eea55b61",{"_118":452,"_144":-5,"_116":453,"_113":454},10,["D",1730904751726],"c02daf54-9c4e-11ef-ab4c-de64eea55b61",{"_118":456,"_144":-5,"_116":457,"_113":458},9,["D",1730904705546],"a4a9bcb4-9c4e-11ef-8e2d-de64eea55b61",{"_118":460,"_144":-5,"_116":461,"_113":462},8,["D",1730904666126],"8d2778d8-9c4e-11ef-8cc3-de64eea55b61",{"_118":464,"_144":-5,"_116":465,"_113":466},7,["D",1730902864381],"5b3ba820-9c4a-11ef-8cd1-de64eea55b61",{"_118":468,"_144":-5,"_116":469,"_113":470},6,["D",1730902794388],"31836d9c-9c4a-11ef-a006-de64eea55b61",{"_118":472,"_144":-5,"_116":473,"_113":474},5,["D",1730902738129],"0ffb5018-9c4a-11ef-b5a5-de64eea55b61",{"_118":123,"_144":-5,"_116":476,"_113":477},["D",1730902693486],"f560530c-9c49-11ef-88d7-de64eea55b61",{"_118":479,"_144":-5,"_116":480,"_113":481},3,["D",1730902693334],"f5480306-9c49-11ef-a3e0-de64eea55b61",{"_118":90,"_144":-5,"_116":483,"_113":484},["D",1730902693038],"f538d9e4-9c49-11ef-82a7-de64eea55b61",{"_118":126,"_144":-5,"_116":486,"_113":487},["D",1730902673406],"e967353e-9c49-11ef-a27a-de64eea55b61",{"_118":31,"_144":-5,"_116":489,"_113":490},["D",1730902562718],"a771fbaa-9c49-11ef-8c5c-de64eea55b61","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":498,"_499":500,"_94":501},"single","redirect","/v/nulo/mileiShowGraph/versions",{"_113":173,"_114":502,"_118":171,"_116":503,"_504":99,"_100":101,"_108":109,"_131":132,"_11":96,"_505":-5,"_506":-5,"_507":-5,"_495":26,"_137":138},"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\"; //\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport {\n CartesianGrid,\n Legend,\n Line,\n LineChart,\n ResponsiveContainer,\n Tooltip,\n XAxis,\n YAxis,\n} from \"https://esm.sh/recharts@2.7.2?deps=react@18.2.0,react-dom@18.2.0\";\n\nfunction App({ tweetData }) {\n const [selectedTweetId, setSelectedTweetId] = useState(\"1852746483306492004\");\n const [filteredData, setFilteredData] = useState([]);\n\n useEffect(() => {\n const filtered = tweetData\n .filter(tweet => tweet.id === selectedTweetId)\n .sort((a, b) => a.time - b.time); // Sort by time in ascending order\n setFilteredData(filtered);\n }, [selectedTweetId, tweetData]);\n\n const ids = [...new Set(tweetData.map(t => t.id))];\n const tweets = ids.map(id => tweetData.find(t => t.id === id));\n\n const formatter = new Intl.NumberFormat(\"es\", { notation: \"compact\" });\n const format = (n) => formatter.format(n);\n\n return (\n

Tweet Engagement Over Time

\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 FROM tweets_archive \n ORDER BY time ASC\n `);\n\n const tweetsWithText = await sqlite.execute(`\n select distinct id, json_extract(json, '$.full_text') as text from tweets_archive`);\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: tweetsWithText.rows.find(t => t.id === tweet.id)!.text || \"\",\n }));\n\n return new Response(\n `\n \n \n Tweet Engagement Over Time\n \n \n \n

mileiShowGraph

Version 80