tweets

This is data scraped from swyx's timeline! See blog post

9 rows where "created_at" is on date 2021-08-11 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, created_at (date)

favorite_count 5 ✖

retweeted 2 ✖

source 1 ✖

  • Twitter for iPhone · 9 ✖
id user created_at full_text retweeted_status quoted_status place source truncated display_text_range in_reply_to_status_id in_reply_to_user_id in_reply_to_screen_name geo coordinates contributors is_quote_status retweet_count favorite_count favorited retweeted possibly_sensitive lang ▼ scopes
1425266629017890816 swyx 33521530 2021-08-11T01:23:39+00:00 @ritakozlov_ i mean sure that works too i wouldnt overreact 😅       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 61] 1425265547550158848 232076816 ritakozlov_       0 0 1 0 0   en  
1425267775967096832 swyx 33521530 2021-08-11T01:28:12+00:00 @ritakozlov_ @jasnell reject cloud embrace corn       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 47] 1425267547469848584 232076816 ritakozlov_       0 0 1 0 0   en  
1425297614539423747 swyx 33521530 2021-08-11T03:26:46+00:00 @jsjoeio @Rich_Harris Svelte is the trickle down framework       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 58] 1425183828063047682 1567529924 jsjoeio       0 0 2 0 0   en  
1425301069903523842 swyx 33521530 2021-08-11T03:40:30+00:00 @slightlylate i like the “special occasion food” phrasing! do you think React Server Components solve this problem well? I went back in your history and only saw mentions about JSF but on this specific “turn off clientside JS by default” goal, it is supposed to do that, runtime aside.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 288] 1425137032461004800 229237555 slightlylate       0 0 1 0 0   en  
1425301392323801088 swyx 33521530 2021-08-11T03:41:47+00:00 @QuinnyPig @dumpkopf @LAURIESMOOZ she asked for “highly-respected”       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [34, 66] 1425225538092765185 97114171 QuinnyPig       0 0 2 0 0   en  
1425476793327259651 Trung Phan 🇨🇦 945817135816654848 2021-08-11T15:18:46+00:00 12/ Quick video cut of @elonmusk breaking down SpaceX’s 5-Step design and manufacturing process: https://twitter.com/TrungTPhan/status/1425476793327259651/video/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 96] 1425474192925888515 945817135816654848 TrungTPhan       0 439 1935 0 1 0 en  
1425477419524308994 Justin ETH 💰Samuels 3311526940 2021-08-11T15:21:15+00:00 Everyone attending @renderATL will: 1. Show proof of vaccination or negative COVID test 📝 2. Receive KN95 masks 😷 3. Take an on-site rapid COVID test ⭐️ We’ve taken the unprecedented step of swabbing everyone attending! Learn more here 👉🏾 https://bit.ly/3xBKvSS https://twitter.com/renderATL/status/1425473400957440008     Atlanta 8173485c72e78ca5 Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 270]             1 38 122 0 0 0 en  
1425503610213785600 swyx 33521530 2021-08-11T17:05:19+00:00 RT @ReactSummit: There was a time before #ReactJS, and there will be life after. If you tie yourself too closely to any tech, you might tra… 1425487171172044815 1425487171172044815     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 6 0 0 1   en  
1425513684202258432 swyx 33521530 2021-08-11T17:45:21+00:00 @spitleaf And Staging and UAT       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 29] 1425512781487431683 357427736 spitleaf       0 0 1 0 0   en  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [tweets] (
   [id] INTEGER PRIMARY KEY,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [full_text] TEXT,
   [retweeted_status] INTEGER,
   [quoted_status] INTEGER,
   [place] TEXT REFERENCES [places]([id]),
   [source] TEXT REFERENCES [sources]([id]), [truncated] INTEGER, [display_text_range] TEXT, [in_reply_to_status_id] INTEGER, [in_reply_to_user_id] INTEGER, [in_reply_to_screen_name] TEXT, [geo] TEXT, [coordinates] TEXT, [contributors] TEXT, [is_quote_status] INTEGER, [retweet_count] INTEGER, [favorite_count] INTEGER, [favorited] INTEGER, [retweeted] INTEGER, [possibly_sensitive] INTEGER, [lang] TEXT, [scopes] TEXT,
   FOREIGN KEY([retweeted_status]) REFERENCES [tweets]([id]),
   FOREIGN KEY([quoted_status]) REFERENCES [tweets]([id])
);
CREATE INDEX [idx_tweets_source]
    ON [tweets] ([source]);