tweets
6 rows where "created_at" is on date 2021-08-17, favorite_count = 4 and is_quote_status = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source, retweet_count, retweeted
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1427461696734449666 | swyx 33521530 | 2021-08-17T02:46:04+00:00 | @MathCrln right, some people really treat 3 as “normal” and others wont give anything less than a 5, need to give guidelines to norm everyone. then again theyd probably ignore it unless you make it in-your-face | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 212] | 1427459133419229189 | 369219338 | MathCrln | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1427466290923409410 | swyx 33521530 | 2021-08-17T03:04:19+00:00 | @mike_hasarms @Daniel0x6019 whats in my mind https://twitter.com/swyx/status/1427466290923409410/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [28, 44] | 1427465581293309953 | 123131219 | mike_hasarms | 0 | 0 | 4 | 0 | 0 | 0 | en | |||||||
1427669027913015300 | swyx 33521530 | 2021-08-17T16:29:55+00:00 | @andrewingram @_philpl i have historically underestimated how crazy things can get but my sense is this would not be feasible given how Apollo relies on interop with the rest of the GraphQL ecosystem. More likely that they define a proprietary superset, which effectively each vendor needs to do anyway. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [23, 303] | 1427667480139403265 | 9164512 | andrewingram | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1427673244358774786 | Jamund Ferguson 119903601 | 2021-08-17T16:46:40+00:00 | Been learning more about dev-rel lately and this article from @swyx was incredible! https://www.swyx.io/measuring-devrel | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 107] | 0 | 2 | 4 | 0 | 1 | 0 | en | ||||||||||
1427775806223257600 | swyx 33521530 | 2021-08-17T23:34:13+00:00 | @clemmihai and doing it so well 👏 you make it look easy even tho i know it couldnt be easy. come so far from your @fullstack days! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 130] | 1427732369876807687 | 4796832195 | clemmihai | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1427776791762984967 | swyx 33521530 | 2021-08-17T23:38:08+00:00 | @EugeneNg_VCap ambition and vision is good and all but i really wish he had talked about serving customers or community instead of being so fixated on valuation. down that path lies a lot of corpses of companies ruined by giant egos putting money over people. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 259] | 1427734201017589763 | 915576521129041920 | EugeneNg_VCap | 0 | 0 | 4 | 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]);