tweets

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

18 rows where "created_at" is on date 2021-12-19, retweet_count = 0 and retweeted = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
1472451038569394176 swyx 33521530 2021-12-19T06:17:39+00:00 @joeDmarti @chriscoyier the other half is telling your coworker their Notion doc is still private       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [24, 97] 1471310626723008517 19720110 joeDmarti       0 0 10 0 0   en  
1472496800808726529 swyx 33521530 2021-12-19T09:19:29+00:00 @leemallon just the touristy stuff is a good 4-5 days. i like the parks @nparksbuzz https://www.nparks.gov.sg/ and ofc the food. these days i try to optimize for people over things when it comes to touristing.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 207] 1472495861435404289 40069321 leemallon       0 0 2 0 0 0 en  
1472504038189330436 swyx 33521530 2021-12-19T09:48:15+00:00 @zerok @temporalio hey thanks for picking up on the @changelog podcast! this is a really great intro, and if you want us to present at your company/user group just let us know!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 176] 1472259615576539140 1348381 zerok       0 0 2 0 0   en  
1472508231667060746 swyx 33521530 2021-12-19T10:04:54+00:00 @heikkila_marko @temporalio interesting, never heard of Benthos before this. how would you connect them? perhaps a quick diagram could help. we often see users trying to put Kafka atop us and there are some good and bad ways to do that       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [28, 235] 1472482970468560900 62916944 heikkila_marko       0 0 0 0 0   en  
1472508357395488768 swyx 33521530 2021-12-19T10:05:24+00:00 @lorendsr @jasonlaster11 @temporalio you know how to find me or Loren anytime :)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [37, 80] 1472367150849576967 215488966 lorendsr       0 0 0 0 0   en  
1472511263221907460 swyx 33521530 2021-12-19T10:16:57+00:00 @_rychen no quarantine for visitors from 11 approved countries https://www.visitsingapore.com/travel-requirements/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 86] 1472509589782417409 192524919 _rychen       0 0 1 0 0 0 en  
1472513148540551172 swyx 33521530 2021-12-19T10:24:27+00:00 @css @ericwbailey oh man, people are dropping all sorts of 🔥 advice on this end of year roundup and it's looking like i'm the only one that submitted a "fun" entry... 🙈       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [18, 168] 1468294550691016709 285019665 css       0 0 0 0 0   en  
1472524132147363842 swyx 33521530 2021-12-19T11:08:05+00:00 @_tamasik_ @kevinakwok @hus_qy what i wouldve given to be at this dinner table without the benefit of hindsight https://twitter.com/swyx/status/1472524132147363842/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [31, 111] 1472257534375301122 1181649390034767872 _tamasik_       0 0 2 0 0 0 en  
1472524257502531585 swyx 33521530 2021-12-19T11:08:35+00:00 @nhr_ackerman i’ve lived in SF.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 31] 1472522314315034624 726025657310953472 nhr_ackerman       0 0 6 0 0   en  
1472527354807615492 swyx 33521530 2021-12-19T11:20:54+00:00 @DouglasBShaw @notdetails https://twitter.com/potatojunkie/status/1470366530936483841?s=21   1470366530936483841 1470366530936483841   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 49] 1471832929198395399 18737948 DouglasBShaw       1 0 1 0 0 0 und  
1472625240693903361 swyx 33521530 2021-12-19T17:49:52+00:00 @mfcodeworks thank you for signaling the quality of your opinions.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 66] 1472607606904549378 4888236412 mfcodeworks       0 0 1 0 0   en  
1472626052656603137 swyx 33521530 2021-12-19T17:53:05+00:00 @anthonycook https://youtu.be/M6S8MMI9lko       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 36] 1472583261964668941 1435674938313170944 anthonycook       0 0 1 0 0 0 und  
1472636601796730880 swyx 33521530 2021-12-19T18:35:00+00:00 @sheldon_hull 3 of those 4 locations are free to access and the aquarium costs like 20 bucks. there is high inequality yes but it happens in private islands and compounds and stuff whereas the big things are all pretty accessible to all. migrant labor quality of life isnt great, I’ll say that       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 294] 1472632603333251074 247477081 sheldon_hull       0 0 1 0 0   en  
1472638202183774209 swyx 33521530 2021-12-19T18:41:22+00:00 @lynnetye next year!! but it was really great to hang out! i’ll see you again in March!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 87] 1472580586430623749 862120536 lynnetye       0 0 1 0 0   en  
1472638612776755206 swyx 33521530 2021-12-19T18:43:00+00:00 @BenLesh @nhr_ackerman and i just spent 6 months in Seattle lol       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [23, 63] 1472603945201713153 23795212 BenLesh       0 0 1 0 0   en  
1472640513824096257 swyx 33521530 2021-12-19T18:50:33+00:00 @wongmjane @BenLesh @nhr_ackerman Jannne why u always up so late haha       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [34, 69] 1472639287715774466 337119125 wongmjane       0 0 3 0 0   en  
1472642322831536130 swyx 33521530 2021-12-19T18:57:44+00:00 @auchenberg ill be back next year yeah       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 38] 1472641525490225154 14810761 auchenberg       0 0 1 0 0   en  
1472643348725133312 swyx 33521530 2021-12-19T19:01:49+00:00 @xjamundx was really good to hang out!! wanted to meet you ever since Kent credited you for getting his career going :)       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 119] 1472615429302484999 119903601 xjamundx       0 0 2 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]);