tweets
5 rows where "created_at" is on date 2021-11-24 and favorite_count = 2 sorted by geo
This data as json, CSV (advanced)
Suggested facets: source, retweet_count
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1463304446415302659 | swyx 33521530 | 2021-11-24T00:32:21+00:00 | @acemarke @jasonclarkedev @freeCodeCamp what! i thought i updated it! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [40, 69] | 1463301457814470661 | 727704217012604928 | acemarke | 0 | 1 | 2 | 0 | 0 | en | ||||||||
1463315592207761411 | swyx 33521530 | 2021-11-24T01:16:38+00:00 | @devongovett @jkup honestly curious what is keeping your at Adobe at this point. ofc i really admire you for your stance on open source for the sake of open source, but also the money is incredibly hard to resist | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [19, 212] | 1463217548191838211 | 15687937 | devongovett | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1463369680177876993 | swyx 33521530 | 2021-11-24T04:51:34+00:00 | @jasonlaster11 @jkup @alexellisuk @Netlify @vercel @remix_run @rometools @replayio @Replit @supabase the @rometools shade | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [101, 121] | 1463367617318514691 | 312750384 | jasonlaster11 | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1463577714045063178 | swyx 33521530 | 2021-11-24T18:38:13+00:00 | @chloe_alabama @seldo The Avengers are 7-0 in battles that include Hawkeye. They are 0-4 in battles either against him or without him. If you are a data analyst you have to conclude Hawkeye is statistically the most valuable avenger | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 232] | 1463552770871595023 | 1359199546346270728 | chloe_alabama | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1463630230665367558 | swyx 33521530 | 2021-11-24T22:06:54+00:00 | @SaraJChipps @cherthedev @levlinds @bitandbang indeed the sheer credentialism and gatekeeping in traditional tech fields has made me start asking “have you thought about web3?” when aspiring developers ask me about how to break into tech. i can’t recommend it bc i haven’t done it, but it’s clearly far more welcoming. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [47, 318] | 1463584905254916098 | 15524875 | SaraJChipps | 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]);