tweets

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

6 rows where "created_at" is on date 2021-07-28 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range

favorite_count 4 ✖

retweeted 2 ✖

user 1 ✖

source 1 ✖

  • Twitter for iPhone · 6 ✖

created_at (date) 1 ✖

  • 2021-07-28 · 6 ✖
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
1420174513824620546 swyx 33521530 2021-07-28T00:09:24+00:00 @monicalimco look at my blog analytics lol       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 42] 1419848153428234248 1265436714136297473 monicalimco       0 0 22 0 0   en  
1420174594644742156 swyx 33521530 2021-07-28T00:09:43+00:00 RT @DominikTornow: @temporalio is all about scalability and reliability while guaranteeing functional correctness. There is a lot to unpac… 1420085405349662721 1420085405349662721     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 7 0 0 1   en  
1420211877276049408 swyx 33521530 2021-07-28T02:37:52+00:00 @matiasfha @Rich_Harris @stolinski @gndx Svelte also has one way data flow under the hood, but uses binding and syntax sugar to simulate LOCAL two way data flow. its not that different. data propagation with stores vs context however are very different.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [41, 255] 1420201456108441603 12816182 matiasfha       0 2 24 0 0   en  
1420234701059416066 swyx 33521530 2021-07-28T04:08:34+00:00 RT @supabase: #supalaunchweek Day 2: 🔥 Supabase Storage is now in Beta 🔥 https://supabase.io/blog/2021/07/27/storage-beta - Streaming Media - Public Buckets - No… 1420043000344768517 1420043000344768517     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 32 0 0 1 0 en  
1420235876483813378 swyx 33521530 2021-07-28T04:13:14+00:00 @lesliecdubs @tiberriver256 wow what a well written blogpost       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [28, 60] 1420188172726771714 22217773 lesliecdubs       0 0 1 0 0   en  
1420309857895272456 swyx 33521530 2021-07-28T09:07:12+00:00 @Andy_W_Farrell @maxlynch @benedictfritz and yet. any company large enough is not homogeneous. they can use multiple frameworks in different apps. willing to bet that react is majority of greenfield.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [41, 199] 1420167119337967620 17500142 Andy_W_Farrell       0 0 0 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]);