tweets

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

5 rows where "created_at" is on date 2021-09-06 and source = "574fe4fa937eeb131136f7e3678f32d4ff3078d5" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_quote_status, retweet_count, favorite_count

source 1 ✖

  • Twitter for iPad · 5 ✖

created_at (date) 1 ✖

  • 2021-09-06 · 5 ✖
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
1434683689670225929 swyx 33521530 2021-09-06T01:03:41+00:00 @geoffrich_ @FredKSchott exactly       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [25, 32] 1434665721879941120 886958568427077632 geoffrich_       0 0 1 0 0   en  
1434809253152362496 swyx 33521530 2021-09-06T09:22:38+00:00 @markdalgleish @rainbowdotme congrats! if you get the time i’d really love a good ol’ blogpost on what specifically draws you to crypto in general, and Rainbow in particular. this space is full of hucksters so always meaningful to have perspectives from “real” folks       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [29, 266] 1434677066692116483 257765996 markdalgleish       0 1 26 0 0   en  
1434818980439592966 swyx 33521530 2021-09-06T10:01:17+00:00 GPTs contrasted with “Management Technologies”, like the assembly line, and possibly software? Software internally has GPTs too, though i am not very convinced by the ones listed here. https://twitter.com/Vernon3Austin/status/1425462308105564168 https://twitter.com/swyx/status/1434818980439592966/photo/1       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 209] 1362333935322075139 33521530 swyx       1 0 3 0 0 0 en  
1434826976884314113 swyx 33521530 2021-09-06T10:33:03+00:00 “Thinking for yourself means finding yourself, finding your own reality. Here’s the [problem with Twitter]... you are continuously bombarding yourself with a stream of other people’s thoughts.” Not sure if recommending this helps or hurts, too much meta https://theamericanscholar.org/solitude-and-leadership/       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 280]             0 2 11 0 0 0 en  
1434832515378843654 swyx 33521530 2021-09-06T10:55:04+00:00 @fakebaldur ha! didnt know that! all great speeches cherry-pick for the story they tell i guess.       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [12, 96] 1434830446764961793 805850 fakebaldur       0 0 1 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]);