tweets

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

5 rows where "created_at" is on date 2021-12-06 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, retweet_count, favorited, created_at (date)

user 2 ✖

retweeted 2 ✖

source 1 ✖

  • Twitter for iPhone · 5 ✖

is_quote_status 1 ✖

  • 0 5
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
1467666370988965888 swyx 33521530 2021-12-06T01:25:05+00:00 RT @mojombo: When I was interviewed on Live TV by Fox News after the big GitHub Series A, they got the investor wrong, spelled "repository"… 1458878468150620181 1458878468150620181     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 6 0 1 1   en  
1467772165466431492 swyx 33521530 2021-12-06T08:25:28+00:00 Was going thru my old 2010-2014 laptop and realized there was no way to play anything at >1x speed back then. A decade later and I chafe at my 1.5x Netflix, blast through podcasts at 2x, and VCs discuss how to find 10x developers. We’ve been frogs, and the water’s come to boil.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 283]             0 0 20 0 0   en  
1467772242029277184 swyx 33521530 2021-12-06T08:25:47+00:00 @kilianvalkhof @argyleink thanks vm Kilian!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 44] 1467435250687033347 9335882 kilianvalkhof       0 0 1 0 0   en  
1467892371480186886 joel ⛈ 12087242 2021-12-06T16:23:08+00:00 these 20 awesome courses are free for the month https://egghead.io/20-days       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 71]             0 66 193 1 1 0 en  
1467958083007565826 swyx 33521530 2021-12-06T20:44:14+00:00 RT @jasonlaster11: http://Replay.io just shipped a new Outline View that can easily show ~50k functions in a file 🚀 If you’re looki… 1467947006911864832 1467947006911864832     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 5 0 1 1 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]);