tweets

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

4 rows where display_text_range = "[0, 196]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, retweet_count, favorited, retweeted, 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
1433446615776313348 Anan Batra 1264520152508481537 2021-09-02T15:08:00+00:00 📍Today - Listnr, Inc. is 1 year and 1 day old 🥳 Here's a quick read on how we scaled Listnr, Inc. from 0 to $150k in revenue without any external funding in under 1 year! https://blog.listnr.tech/blogs/listnr-1-year       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 196]             0 7 92 0 0 0 en  
1443381760935534592 emily freeman 1066151600 2021-09-30T01:06:43+00:00 I’m pretty proud of this. It represents roughly six months of my work and I’m hopeful that it will get the conversation started on what’s next for DevOps. More to come! https://flip.it/g7vdf2       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 196]             0 196 1575 0 0 0 en  
1452772699512524800 swyx 33521530 2021-10-25T23:02:57+00:00 Looking forward to host the 7th @temporalio meetup tomorrow at 9am PT! Presenting: 💰 Temporal at @Stripe 🗺️ Temporal Feature Map 🎉 2 Year Anniversary Q&A Signup at https://temporal.io/meetup!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 196]             0 5 15 0 0 0 en  
1467947006911864832 Jason Laster 312750384 2021-12-06T20:00:14+00:00 http://Replay.io just shipped a new Outline View that can easily show ~50k functions in a file 🚀 If you’re looking to add a print statement in a file, the Outline View is your friend! 1/3 https://twitter.com/jasonlaster11/status/1467947006911864832/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 196]             0 5 73 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]);