tweets

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

8 rows where "created_at" is on date 2021-08-21, retweet_count = 0 and retweeted = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, is_quote_status, favorite_count, lang, created_at (date)

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
1428869838991028226 swyx 33521530 2021-08-21T00:01:31+00:00 @sjroot @WaveConnects       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 21] 1428864630093398019 1624166100 sjroot       0 0 0 0 0   und  
1428933561835421696 swyx 33521530 2021-08-21T04:14:44+00:00 Connected with a clinical psychologist over our mutual suspicion of Enneagrams today TIL that there are more developed alternatives to the Big 5 OCEAN Personality traits: MMPI: ~500 questions https://en.wikipedia.org/wiki/Minnesota_Multiphasic_Personality_Inventory MCMI: ~200 questions https://en.wikipedia.org/wiki/Millon_Clinical_Multiaxial_Inventory fascinating! https://twitter.com/swyx/status/1428933561835421696/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 276]             0 0 7 0 0 0 en  
1428933790458548229 swyx 33521530 2021-08-21T04:15:38+00:00 @supabase dropping just the right meme at just the right moment https://twitter.com/swyx/status/1428933790458548229/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 63] 1428750221945708553 1219566488325017602 supabase       0 0 30 0 0 0 en  
1428952881646821389 swyx 33521530 2021-08-21T05:31:30+00:00 @kevinakwok https://twitter.com/swyx/status/1428952881646821389/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 11] 1428919435176329216 169791252 kevinakwok       0 0 1 0 0 0 und  
1429158259609399296 swyx 33521530 2021-08-21T19:07:36+00:00 @rcdexta hmm thank you for this tip! i have a Nighthawk gaming router from Netgear and it looks like it does have DFS. will try!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 128] 1429156611658960899 225288961 rcdexta       0 0 0 0 0   en  
1429159691452436482 swyx 33521530 2021-08-21T19:13:17+00:00 @simonw @datasetteproj very frustrating. sorry to hear. had this happen to @Coding_Career twice. both times basically had to know someone in Twitter to escalate it :(       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [23, 166] 1428971520269844480 12497 simonw       0 0 0 0 0   en  
1429170239598587910 swyx 33521530 2021-08-21T19:55:12+00:00 @arahansen they are where you are! Twitter, YouTube, HN, Reddit, Discord. Seek out people on the same path as you, by definition, they should be easy to find. Learn to distinguish the tourists from the serious learners/builders. to connect with higher profile mentors and sponsors: https://twitter.com/swyx/status/1385354953468772356   1385354953468772356 1385354953468772356   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 282] 1429164237364944900 360717290 arahansen       1 0 1 0 0 0 en  
1429171230289010690 swyx 33521530 2021-08-21T19:59:08+00:00 @bassett_green @berryfairyland @3renshoPies @jodyavirgan i mean technically it did, i prefer to say the train overachieved       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [57, 122] 1429047565014781952 211740329 bassett_green       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]);