tweets
22 rows where "created_at" is on date 2021-12-19 sorted by lang
This data as json, CSV (advanced)
Suggested facets: is_quote_status, retweet_count, favorited, lang, created_at (date)
user 2 ✖
- swyx 21
- Balaji Srinivasan 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1472451038569394176 | swyx 33521530 | 2021-12-19T06:17:39+00:00 | @joeDmarti @chriscoyier the other half is telling your coworker their Notion doc is still private | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 97] | 1471310626723008517 | 19720110 | joeDmarti | 0 | 0 | 10 | 0 | 0 | en | ||||||||
1472495199322624003 | swyx 33521530 | 2021-12-19T09:13:07+00:00 | I am back in Singapore 🇸🇬 Never spending another winter in a cold country again. Come visit when it’s safe, it will change what you think a city can be. https://twitter.com/swyx/status/1137356384796794880 | 1137356384796794880 1137356384796794880 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 154] | 1 | 6 | 433 | 0 | 0 | 0 | en | |||||||||
1472496800808726529 | swyx 33521530 | 2021-12-19T09:19:29+00:00 | @leemallon just the touristy stuff is a good 4-5 days. i like the parks @nparksbuzz https://www.nparks.gov.sg/ and ofc the food. these days i try to optimize for people over things when it comes to touristing. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 207] | 1472495861435404289 | 40069321 | leemallon | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1472504038189330436 | swyx 33521530 | 2021-12-19T09:48:15+00:00 | @zerok @temporalio hey thanks for picking up on the @changelog podcast! this is a really great intro, and if you want us to present at your company/user group just let us know! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 176] | 1472259615576539140 | 1348381 | zerok | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1472508231667060746 | swyx 33521530 | 2021-12-19T10:04:54+00:00 | @heikkila_marko @temporalio interesting, never heard of Benthos before this. how would you connect them? perhaps a quick diagram could help. we often see users trying to put Kafka atop us and there are some good and bad ways to do that | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [28, 235] | 1472482970468560900 | 62916944 | heikkila_marko | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1472508357395488768 | swyx 33521530 | 2021-12-19T10:05:24+00:00 | @lorendsr @jasonlaster11 @temporalio you know how to find me or Loren anytime :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [37, 80] | 1472367150849576967 | 215488966 | lorendsr | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1472511263221907460 | swyx 33521530 | 2021-12-19T10:16:57+00:00 | @_rychen no quarantine for visitors from 11 approved countries https://www.visitsingapore.com/travel-requirements/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 86] | 1472509589782417409 | 192524919 | _rychen | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1472513148540551172 | swyx 33521530 | 2021-12-19T10:24:27+00:00 | @css @ericwbailey oh man, people are dropping all sorts of 🔥 advice on this end of year roundup and it's looking like i'm the only one that submitted a "fun" entry... 🙈 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [18, 168] | 1468294550691016709 | 285019665 | css | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1472524132147363842 | swyx 33521530 | 2021-12-19T11:08:05+00:00 | @_tamasik_ @kevinakwok @hus_qy what i wouldve given to be at this dinner table without the benefit of hindsight https://twitter.com/swyx/status/1472524132147363842/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [31, 111] | 1472257534375301122 | 1181649390034767872 | _tamasik_ | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1472524257502531585 | swyx 33521530 | 2021-12-19T11:08:35+00:00 | @nhr_ackerman i’ve lived in SF. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 31] | 1472522314315034624 | 726025657310953472 | nhr_ackerman | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1472622049554100226 | Balaji Srinivasan 2178012643 | 2021-12-19T17:37:11+00:00 | Ok, @levie proposed a space on web3 so let’s try it. Cc @joshelman @zachweinberg https://twitter.com/i/spaces/1yoKMWObkVkJQ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 105] | 0 | 53 | 274 | 1 | 1 | 0 | en | ||||||||||
1472625240693903361 | swyx 33521530 | 2021-12-19T17:49:52+00:00 | @mfcodeworks thank you for signaling the quality of your opinions. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 66] | 1472607606904549378 | 4888236412 | mfcodeworks | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1472629089164951554 | swyx 33521530 | 2021-12-19T18:05:09+00:00 | RT @balajis: Ok, @levie proposed a space on web3 so let’s try it. Cc @joshelman @zachweinberg https://twitter.com/i/spaces/1yoKMWObkVkJQ | 1472622049554100226 1472622049554100226 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 118] | 0 | 53 | 0 | 1 | 1 | 0 | en | |||||||||
1472636601796730880 | swyx 33521530 | 2021-12-19T18:35:00+00:00 | @sheldon_hull 3 of those 4 locations are free to access and the aquarium costs like 20 bucks. there is high inequality yes but it happens in private islands and compounds and stuff whereas the big things are all pretty accessible to all. migrant labor quality of life isnt great, I’ll say that | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 294] | 1472632603333251074 | 247477081 | sheldon_hull | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1472638202183774209 | swyx 33521530 | 2021-12-19T18:41:22+00:00 | @lynnetye next year!! but it was really great to hang out! i’ll see you again in March! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 87] | 1472580586430623749 | 862120536 | lynnetye | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1472638612776755206 | swyx 33521530 | 2021-12-19T18:43:00+00:00 | @BenLesh @nhr_ackerman and i just spent 6 months in Seattle lol | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 63] | 1472603945201713153 | 23795212 | BenLesh | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1472640513824096257 | swyx 33521530 | 2021-12-19T18:50:33+00:00 | @wongmjane @BenLesh @nhr_ackerman Jannne why u always up so late haha | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [34, 69] | 1472639287715774466 | 337119125 | wongmjane | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1472642322831536130 | swyx 33521530 | 2021-12-19T18:57:44+00:00 | @auchenberg ill be back next year yeah | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 38] | 1472641525490225154 | 14810761 | auchenberg | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1472643348725133312 | swyx 33521530 | 2021-12-19T19:01:49+00:00 | @xjamundx was really good to hang out!! wanted to meet you ever since Kent credited you for getting his career going :) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 119] | 1472615429302484999 | 119903601 | xjamundx | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1472471158926630913 | swyx 33521530 | 2021-12-19T07:37:36+00:00 | RT @solarpunkgirl: https://twitter.com/solarpunkgirl/status/1472230116281491464/video/1 | 1472230116281491464 1472230116281491464 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 42] | 0 | 456 | 0 | 1 | 1 | 0 | und | |||||||||
1472527354807615492 | swyx 33521530 | 2021-12-19T11:20:54+00:00 | @DouglasBShaw @notdetails https://twitter.com/potatojunkie/status/1470366530936483841?s=21 | 1470366530936483841 1470366530936483841 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 49] | 1471832929198395399 | 18737948 | DouglasBShaw | 1 | 0 | 1 | 0 | 0 | 0 | und | ||||||
1472626052656603137 | swyx 33521530 | 2021-12-19T17:53:05+00:00 | @anthonycook https://youtu.be/M6S8MMI9lko | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 36] | 1472583261964668941 | 1435674938313170944 | anthonycook | 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]);