This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5730 | 5730 | 1900-07-21 | 3 | a | Trouble comes if one does not speak cautiously. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102881 | 24102881 | |
5731 | 5731 | 1900-07-21 | 3 | b | Chinese community in Sydney prepares to celebrate birthday of the Emperor. The committee of celebration includes Li Ruxing, Ouyang Qing, Zheng Fanchang, Wu Jichuan, Chen Shou, Xian Junhao, Li Guanyi, Mei Bing, Miu Dianchen, Wu Yanfan, Ou Bin, Guan Zhuobo, Guo Biao, Chen Lianke, Liang Chuang, Xia Congzhou, He Yao, and Wu Jiaji. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102881 | 24102881 | |
5732 | 5732 | 1900-07-21 | 3 | b | Bandits gathered in Wuzhou, Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24102881 | 24102881 | |
5733 | 5733 | 1900-07-21 | 3 | b | Gentry in Guangzhou request Li Hongzhang to stay in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24102881 | 24102881 | |
5734 | 5734 | 1900-07-21 | 3 | c | Li Hongzhang's reply to the request put forward to him by Guangzhou gentry. | China | http://trove.nla.gov.au/newspaper/page/24102881 | 24102881 | |
5735 | 5735 | 1900-07-21 | 3 | c | Mail from China awaiting collection. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102881 | 24102881 | |
5736 | 5736 | 1900-07-21 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102881 | 24102881 |
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]);