tweets

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

16 rows where "created_at" is on date 2021-12-19 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: favorited, lang

created_at (date) 1 ✖

  • 2021-12-19 · 16 ✖
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  
1472495199322624003 swyx 33521530 2021-12-19T09:13:07+00:00 I am back in Singapore 🇸🇬 Never spending another winter in a cold country again. Come visit when it’s safe, it will change what you think a city can be. https://twitter.com/swyx/status/1137356384796794880   1137356384796794880 1137356384796794880   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 154]             1 6 433 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  
1472622049554100226 Balaji Srinivasan 2178012643 2021-12-19T17:37:11+00:00 Ok, @levie proposed a space on web3 so let’s try it. Cc @joshelman @zachweinberg https://twitter.com/i/spaces/1yoKMWObkVkJQ       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 105]             0 53 274 1 1 0 en  
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  
1472629089164951554 swyx 33521530 2021-12-19T18:05:09+00:00 RT @balajis: Ok, @levie proposed a space on web3 so let’s try it. Cc @joshelman @zachweinberg https://twitter.com/i/spaces/1yoKMWObkVkJQ 1472622049554100226 1472622049554100226     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 118]             0 53 0 1 1 0 en  
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  
1472471158926630913 swyx 33521530 2021-12-19T07:37:36+00:00 RT @solarpunkgirl: https://twitter.com/solarpunkgirl/status/1472230116281491464/video/1 1472230116281491464 1472230116281491464     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 42]             0 456 0 1 1 0 und  
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  
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  

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