This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20249 | 20249 | 1908-11-14 | 6 | b | Japanese in Honolulu boycott Chinese fishing. Chinese businessmen in Singapore promote Chinese local products. Report on the boycott of Japanese goods in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801952 | 26801952 | |
20250 | 20250 | 1908-11-14 | 6 | b | Miscellaneous report. Boycott of Japanese goods in Hong Kong. Hundreds of thousands of lamas are on riots in Tibet and response of Chinese authority and army. Republic candidate William Howard Taft has been elected next president of the United States. A Chinese passenger liner sinks on the way from Xiamen to Dongjian. | Britain | http://trove.nla.gov.au/newspaper/page/26801952 | 26801952 | |
20258 | 20258 | 1908-11-14 | 7 | b | Reader Feng Kaitai reports that a passenger liner is stranded on its way from Sydney to Cairns. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801951 | 26801951 |
JSON shape: default, array, newline-delimited
CREATE TABLE [article_index] ( [date] TEXT, [page] TEXT, [column] TEXT, [title] TEXT, [description] TEXT, [source] TEXT, [page_url] TEXT, [trove_id] TEXT ); CREATE INDEX [idx_article_index_date] ON [article_index] ([date]);