[{"_1":2,"_166":-5,"_167":-5},"loaderData",{"_3":4,"_91":92,"_154":155,"_165":-5},"root",{"_5":6,"_32":33,"_58":59,"_89":90},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":29,"_30":31},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"sessionClaims","sessionId","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","fa80b67e1f763bfb4b247c3f5ca4f0b0730f3f5c","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","API_URL","https://api.val.town","WORKER_FINGERPRINT","799d99f2805306c2714a7cfefbeae178","clerkState",{"_60":61},"__internal_clerk_state",{"_62":63,"_64":43,"_65":66,"_67":66,"_68":26,"_69":66,"_70":66,"_71":66,"_72":66,"_73":66,"_74":66,"_75":66,"_76":66,"_77":78,"_87":26,"_88":26},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_79":26,"_80":66,"_81":82,"_83":66,"_84":43,"_85":26,"_86":66},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.v.$handle.$name",{"_93":94,"_95":96,"_94":97,"_149":-5,"_150":-5,"_151":152,"_128":129,"_142":143,"_100":101,"_98":99,"_117":-7,"_50":51,"_153":26},"type","val","author","418c1e39-eb48-4f2f-8c97-122ece94631c",{"_98":99,"_95":96,"_100":101,"_102":-5,"_103":-5,"_104":105,"_106":66,"_107":108,"_109":110,"_111":26,"_112":110,"_113":114,"_115":116,"_117":31,"_118":26,"_119":31,"_120":31,"_121":31,"_122":123,"_124":31,"_125":31,"_126":-5,"_20":127,"_132":133,"_139":-7,"_140":141,"_142":143,"_144":145},"name","brightSalmonHoverfly","valNameId","06661102-e4aa-11ef-a3c7-e6cdfca9ef9f","parentFolderId","isOwned","privacy","public","readme","valType","http","currentVersion","068a940a-e4aa-11ef-a3c7-e6cdfca9ef9f","legacyPrivate","id","code","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useEffect, useState } from \"https://esm.sh/react@18.2.0?deps=react-dom@18.2.0\";\n// x\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=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 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",1738860437455],"version","currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_128":129,"_130":131},"handle","maxm","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJnTEtkSHlOMWxWZm1GRHdKYUVTNklYM3FpdiJ9","forkedVal",{"_112":134,"_128":135,"_98":136,"_117":137,"_138":-5},"ddcb14f0-e4a8-11ef-aeb0-e6cdfca9ef9f","nulo","mileiShowGraph",85,"prDisabledHint","interval","slug","maxm/brightSalmonHoverfly","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[146],{"_117":31,"_147":-5,"_115":148,"_112":110},"prId",["D",1738860437455],"recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":156,"_157":158,"_94":159},"single","redirect","/v/maxm/brightSalmonHoverfly/versions",{"_112":110,"_113":114,"_117":31,"_115":160,"_161":99,"_100":101,"_107":108,"_128":129,"_11":96,"_162":-5,"_163":-5,"_164":-5,"_153":26,"_140":141},["D",1738860437455],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

brightSalmonHoverfly

Version 0