tweets
7 rows where favorite_count = 25 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorited, lang
created_at (date) 7 ✖
- 2018-08-16 1
- 2021-08-26 1
- 2021-09-07 1
- 2021-10-19 1
- 2021-12-10 1
- 2021-12-12 1
- 2021-12-24 1
user 2 ✖
- swyx 6
- Madison Kanna 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1030130810588819456 | swyx 33521530 | 2018-08-16T16:34:58+00:00 | Flashing Lights https://twitter.com/swyx/status/1030130810588819456/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 16] | 1030109644075687936 | 33521530 | swyx | 0 | 0 | 25 | 0 | 0 | 0 | en | |||||||
1430685599258734592 | Madison Kanna 1087957969915006976 | 2021-08-26T00:16:42+00:00 | Good article by @swyx on why he changed his mind about Tailwind https://www.swyx.io/why-tailwind | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 88] | 0 | 3 | 25 | 0 | 1 | 0 | en | ||||||||||
1435328837848551427 | swyx 33521530 | 2021-09-07T19:47:16+00:00 | @wongmjane wow the follow button throws special confetti for people who tweet about #AppleEvent!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 97] | 1435276210599198722 | 337119125 | wongmjane | 0 | 0 | 25 | 0 | 0 | en | ||||||||
1469095443732721664 | swyx 33521530 | 2021-12-10T00:03:42+00:00 | @r00k @tailwindcss i was one of those people. i think the technology has to be so ugly upfront as to be offputting, but so valuable when used that people overlook the ugliness. opportunity for that to happen is very rare. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [19, 221] | 1469092324634509315 | 11280212 | r00k | 0 | 0 | 25 | 0 | 0 | en | ||||||||
1469880889312104449 | swyx 33521530 | 2021-12-12T04:04:47+00:00 | @t3dotgg uh wow what? you are super underfollowed, how do i buy stock in your follower count lol | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 96] | 1469858072843620352 | 786375418685165568 | t3dotgg | 0 | 3 | 25 | 0 | 0 | en | ||||||||
1474271524110491649 | swyx 33521530 | 2021-12-24T06:51:36+00:00 | Strong Opinions on heading tags in HTML (h1, h2, h3, etc): - should all have id’s set - should all have discoverable anchor links (see: github markdown, or my blogposts) - (when appropriate) highlight link target, eg when one item in a multiple column layout (using :target) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 275] | 1474267015334752257 | 33521530 | swyx | 0 | 2 | 25 | 1 | 0 | en | ||||||||
1450308708274032642 | swyx 33521530 | 2021-10-19T03:51:56+00:00 | @supabase https://twitter.com/swyx/status/1450308708274032642/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 9] | 1450307400234258435 | 1219566488325017602 | supabase | 0 | 0 | 25 | 0 | 0 | 0 | und |
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]);