tweets
11 rows where "created_at" is on date 2021-10-16 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: favorite_count, retweeted, lang, created_at (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1449163379625451526 | swyx 33521530 | 2021-10-16T00:00:48+00:00 | @brian_lovin ugh OK BRIAN i will blog up something tonight instead of going out | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 79] | 1449064999775703045 | 465068802 | brian_lovin | 0 | 0 | 4 | 0 | 0 | en | ||||||||
| 1449163711877238791 | swyx 33521530 | 2021-10-16T00:02:07+00:00 | @hillelogram this is @alexbdebrie erasure and i wont stand for it | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 65] | 1449062977244651521 | 397782926 | hillelogram | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1449163918157369344 | swyx 33521530 | 2021-10-16T00:02:56+00:00 | @bee_sec_san @jkup @monzo nice! adding to my slides 😊 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 53] | 1449123944372576256 | 117172713 | bee_sec_san | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1449168546198523904 | swyx 33521530 | 2021-10-16T00:21:20+00:00 | RT @MachinePix: Time-lapse of ship locks at the Three Gorges Dam. https://twitter.com/MachinePix/status/1449129896387616771/video/1 | 1449129896387616771 1449129896387616771 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 89] | 0 | 607 | 0 | 0 | 1 | 0 | en | |||||||||
| 1449169373701148673 | swyx 33521530 | 2021-10-16T00:24:37+00:00 | @MachinePix @TaylorPearsonMe just noticed the redundant height of the top doors. the other doors get used on at least one side at all times, but the top doors have no reason to be that high… except for aesthetics, or future levels. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [29, 231] | 1449129896387616771 | 2444425802 | MachinePix | 0 | 0 | 3 | 0 | 0 | en | ||||||||
| 1449172931825700870 | swyx 33521530 | 2021-10-16T00:38:45+00:00 | @andrewingram its a dam… | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 24] | 1449172097075486722 | 9164512 | andrewingram | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1449254218821341187 | swyx 33521530 | 2021-10-16T06:01:46+00:00 | @brian_tran_dev haha great hanging out!! i’m really looking forward to you talking semis with @FoolAllTheTime someday! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 118] | 1449198995130048512 | 1335998147844161538 | _briantran_ | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1449325335615455232 | swyx 33521530 | 2021-10-16T10:44:21+00:00 | @PodRocketpod @DavidKPiano great episode! idk if you’ve considered doing @ycombinator but they have rolling admissions right now and you could prob get a bunch of recs to get on the top of the heap | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 197] | 1449043573031194625 | 1372248310904455178 | PodRocketpod | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1449429691530571776 | swyx 33521530 | 2021-10-16T17:39:02+00:00 | @FoolAllTheTime @brian_tran_dev i should ask you that lol. heading back to Seattle now. Brian here is in LA and is a software dev + semis hobbyist and one of the few people ive met who is excited about Xilinx and AMD and FPGAs. told him to read up on your stuff but not sure how he can turn it into a day job | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [32, 309] | 1449424449569165319 | 986801772676157440 | FoolAllTheTime | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1449446521850580996 | swyx 33521530 | 2021-10-16T18:45:54+00:00 | @stephsmithio for what its worth i really enjoyed this discussion, agree with @calvin_rosser that cutting out news, particularly short lived news, is a pure win. altho perhaps replaced by social media 😛 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 204] | 1449133731340439553 | 626691391 | stephsmithio | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1449281470044852226 | swyx 33521530 | 2021-10-16T07:50:03+00:00 | @JemYoung http://reddit.com/r/ACK | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 33] | 1449235036826312711 | 959539956 | JemYoung | 0 | 0 | 1 | 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]);