tweets

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

18 rows where "created_at" is on date 2021-10-29 and retweet_count = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, is_quote_status, favorite_count, lang

retweet_count 1 ✖

created_at (date) 1 ✖

  • 2021-10-29 · 18 ✖
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
1454228901740220421 swyx 33521530 2021-10-29T23:29:23+00:00 @mpocock1 more like SVG rekt width amirite       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 42] 1454221828415795204 346640777 mpocock1       0 0 7 0 0   de  
1453895441569837059 swyx 33521530 2021-10-29T01:24:19+00:00 RIP @Facebook’s twitter account 🔒 https://twitter.com/swyx/status/1453895441569837059/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 33]             0 0 32 0 0 0 en  
1453900479071543305 swyx 33521530 2021-10-29T01:44:21+00:00 @danielbayerlein @kentcdodds @angular fun fact... she grew up and she is lovely! https://www.youtube.com/watch?v=zB2FEttIoTg       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [38, 104] 1453790386464374790 58160689 danielbayerlein       0 0 3 0 0 0 en  
1453930581226450947 swyx 33521530 2021-10-29T03:43:57+00:00 @threepointone @reactjs @temporalio @statelyai @Shopify omg sunil when you wanted to talk about the Meta was this what you meant       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [56, 131] 1439702355553886211 33521530 swyx       0 0 13 0 0   en  
1454126293943918594 swyx 33521530 2021-10-29T16:41:39+00:00 @Rich_Harris @nytgraphics what a run, Rich. 👏 👏 👏 👏       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 51] 1454088761852276749 19487837 Rich_Harris       0 0 12 0 0   en  
1454133696617869313 swyx 33521530 2021-10-29T17:11:04+00:00 @taniarascia best wrist rest! good for ergonomics       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 49] 1454131881016954882 3580004117 taniarascia       0 0 3 0 0   en  
1454161672449318915 swyx 33521530 2021-10-29T19:02:14+00:00 @rothgar what i wouldnt give for the kubecon sponsor floor to have looked exactly like this       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 91] 1454161147569983490 14361975 rothgar       0 0 3 0 0   en  
1454205465827549188 swyx 33521530 2021-10-29T21:56:15+00:00 Your Halloween name is Spooky + last bug you faced       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 50]             0 0 30 0 0   en  
1454207215267500032 swyx 33521530 2021-10-29T22:03:12+00:00 @DavidKPiano aww thats a cute bug!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 34] 1454206717806403596 992126114 DavidKPiano       0 0 2 0 0   en  
1454208483528626177 swyx 33521530 2021-10-29T22:08:15+00:00 @shaidvck whoa wait does that really happen!? 😱       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 47] 1454208293992165376 14363988 shaidvck       0 0 0 0 0   en  
1454210028374614016 swyx 33521530 2021-10-29T22:14:23+00:00 @KennethCassel well that seems like an easy fix!... i hope       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 58] 1454209766612406275 1319269656264409088 KennethCassel       0 0 1 0 0   en  
1454211652002353158 swyx 33521530 2021-10-29T22:20:50+00:00 Just had a wonderful coaching call with Cristina, strongly recommend for startup folks who may be at an inflection in your career (if you can find a slot 😅) (read up on her before you do: https://www.linkedin.com/in/cristinajcordova/) https://twitter.com/cjc/status/1432467587095359489   1432467587095359489 1432467587095359489   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 213]             1 0 8 0 0 0 en  
1454211768192958467 swyx 33521530 2021-10-29T22:21:18+00:00 @Jennabot5000 all bugs are equally feared in this house no worries       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 66] 1454211279682510856 1293902268979445761 Jennabot5000       0 0 4 0 0   en  
1454212032207618052 swyx 33521530 2021-10-29T22:22:21+00:00 @djwyatt man i really hope that error message spells out what the offending entry is right there in the message or i'm gonna have to send someone my blogpost about doing errors right       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 182] 1454210440452526082 17595855 djwyatt       0 0 3 0 0   en  
1454212219210645504 swyx 33521530 2021-10-29T22:23:05+00:00 @kevinakwok Godwin's Law but wholesome       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 38] 1454210650830426117 169791252 kevinakwok       0 0 1 0 0   en  
1453894452435513348 swyx 33521530 2021-10-29T01:20:24+00:00 @ReactMiamiConf 👀       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 17] 1453737749450612746 1394306514282848260 ReactMiamiConf       0 0 3 0 0   und  
1454132887058468869 swyx 33521530 2021-10-29T17:07:51+00:00 @loujaybee @andrewbrown 👏👏👏👏👏👏👏👏       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 32] 1454128766666543109 1290693397 loujaybee       0 0 1 0 0   und  
1454208230008053761 swyx 33521530 2021-10-29T22:07:14+00:00 @himynameisdave noooooooo       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 25] 1454207414304079874 2290190784 himynameisdave       0 0 2 0 0   und  

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]);