SELECT content.title, content.body, content.published, author.url FROM `200_boards___updated_daily___chinese.socialgist_boards_chinese_public` -- Make sure the dataset and table selectors use the same name you set when you linked the dataset. WHERE LOWER(content.body) LIKE '%经济%' -- The keyword is the word 'economy' in Chinese characters. You can change this to any keyword you wish to scan for in the content body. ORDER BY content.published DESC LIMIT 10 -- Limits the results to 100 for demonstration purposes.
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter