tweets

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

11 rows where favorited = 0 and source = "f0976f342215a984184a13a54b26877ece8cebba"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_quote_status, retweet_count, retweeted, 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
1412032180465831939 Brittney Postma 36686876 2021-07-05T12:54:40+00:00 Check it out, I was on Svelte Radio! I still can't believe it. Thank you for having me, I had so much fun! Also, check out the Purrfect dev with @swyx talking about Svelte. https://codingcat.dev/podcast/1-15-whats-up-with-svelte #svelte @sveltejs https://twitter.com/svelteradio/status/1411882780959596549       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 217]             1 4 31 0 0 0 en  
1429981875259514883 Everyday I wake up 1265057150814031880 2021-08-24T01:40:21+00:00 @SpiderManMovie https://twitter.com/SlamsFist/status/1429981875259514883/photo/1       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [15, 15] 1429981786386403330 281217033 SpiderManMovie       0 839 13809 0 1 0 und  
1433175067563855872 Kasra 1175119837653159936 2021-09-01T21:08:57+00:00 I'm super excited to announce that our work on interactive Program Synthesis with control structures (with @shraddha_96, @HilaCodes, Sorin Lerner, and @polikarn) has been accepted to OOPSLA 2021! More details to come, but here's a sneak preview: https://twitter.com/kasra_ferdowsi/status/1433175067563855872/video/1       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 245]             0 69 384 0 1 0 en  
1435253892523171843 🎙 m4dz 🥑🦄 81091261 2021-09-07T14:49:28+00:00 Deep dive in the #JavaScript's History, where it comes from, and where it goes for the next 10 years. I do love those kind of prospective talks 🤩. Thanks @swyx ! #infobipshift https://twitter.com/m4d_z/status/1435253892523171843/photo/1       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 175]             0 2 12 0 1 0 en  
1435258266729205762 Gil Tayar 8373052 2021-09-07T15:06:51+00:00 VCs are coming to Javascript tooling. Worrying or great for the ecosystem? Good question from @swyx. Lots of good takes on the directions js should go. https://twitter.com/giltayar/status/1435258266729205762/photo/1       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 153]             0 2 13 0 1 0 en  
1440190632761257996 Franco Lombardo 57264296 2021-09-21T05:46:18+00:00 Smart servers or smart clients? Interesting post by @swyx https://www.swyx.io/client-server-battle       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 81]             0 2 4 0 1 0 en  
1446485504468398085 Geoffrey Miller 🔍 3656836876 2021-10-08T14:39:53+00:00 Any school system that doesn't allow separate classes for very smart ('gifted & talented') kids either doesn't understand very smart kids at all, or it sadistically wants them to be suffer through boredom, frustration, alienation, & bullying.       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 250]             0 1039 7594 0 0   en  
1452445875159044098 Lívia Labate 769920 2021-10-25T01:24:16+00:00 A screw it, let's do it: TL,DR: AMP format doesn't support JavaScript in the way you can use it on regular web pages. This prevents publishers from using header bidding with AMP (limits how many ad exchanges one can connect to @ a time, making it less desirable/useful; see doc)       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 280] 1452430810880122885 769920 livlab       0 48 251 0 0   en  
1457887975115612164 Chris DiBona 44423 2021-11-09T01:49:14+00:00 Hey, I did a thing. I'm about to hate listen to myself and be super judgemental. Gotta lance that boil! It's the only way to get better..... https://twitter.com/thenewstack/status/1457830540011245572       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 140]             1 5 45 0 0 0 en  
1467261215915364353 Adam Gordon Bell 🤓 191034488 2021-12-04T22:35:08+00:00 @swyx I wrote a thing about this: https://earthly.dev/blog/confidently-uncertain/       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [6, 57] 1467260899874512906 191034488 adamgordonbell       0 1 6 0 0 0 en  
1470366530936483841 Intercontinental Breakfast Missile 41402543 2021-12-13T12:14:33+00:00 Still thinking about this bird's nest made out of anti-bird spikes https://twitter.com/potatojunkie/status/1470366530936483841/photo/1       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 66]             0 2365 16602 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]);