tweets
4 rows where "created_at" is on date 2021-09-12 and favorite_count = 2 sorted by lang
This data as json, CSV (advanced)
source 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1437025662603341829 | swyx 33521530 | 2021-09-12T12:09:51+00:00 | @simonw @pradyunsg to me, that is @anacondainc - i know it has its drawbacks, but it’s so nice living in Anaconda’s world. I’m unclear about how the larger Python community feels about it (similar to how Apollo dominates GraphQL) but they’ve certainly done a better job than anyone else i know | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [19, 293] | 1436728586669477894 | 12497 | simonw | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1437115127006912514 | swyx 33521530 | 2021-09-12T18:05:21+00:00 | @simonplend lol wow that is such amateur hour. thanks! will need to fix. i dont really like convertkit tbh. think i need to switch to revue. | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [12, 140] | 1437114001851359235 | 34583 | simonplend | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1437116007026499587 | swyx 33521530 | 2021-09-12T18:08:51+00:00 | @KennethCassel @reactjs ironic that your more secure calls are done clientside, whereas general calls are serverside. not what i would have expected! i'd love to read an analysis of RLS vs other authz methods you considered, i'm not well versed enough to decide | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [24, 262] | 1437113888093442050 | 1319269656264409088 | KennethCassel | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1437120500594003968 | swyx 33521530 | 2021-09-12T18:26:42+00:00 | @gusfune @reactjs "kill" is a tricky word.. i really mean "abstract over", but its less of a punchy title tbh | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [18, 109] | 1437119299014037508 | 15359622 | gusfune | 0 | 0 | 2 | 0 | 0 | en |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);