This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33452 | 33452 | 1918-07-20 | 6 | b-c | Report on the floods in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097366 | 24097366 | |
33454 | 33454 | 1918-07-20 | 7 | b-c | Australia news/ Chinese women in Sydney organises a fundraising fete for flooding victims in Guangdong (Mrs Li Xianmin, Mrs Huang Zhu and Zhou Jialing). A Sydney woman celebrates her 105th birthday. A Chinese gardener in Victoria is drowned. An old man in Barthurst, New South Wales, likes to walk. A thief steals from a garrison with truck. A jewellery shop in Pitt Street, Sydney, is burglarised. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097365 | 24097365 | |
33458 | 33458 | 1918-07-20 | 8 | b-c | Beijing news/ Xiong Xiling seeks pardon for Sheng Xuanhuai and Zhang Zhenfang. The Japanese adviser of Chinese government is on holiday leave. Chaos in Russia affect the border of Mongolia. Government troops in Xinjiang on high alert due to the chaos in Russia. Zhang Qingtong is appointed administrator in Xinjiang. Report on the flood in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24097367 | 24097367 |
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]);