This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28679 | 28679 | 1914-04-11 | 2 | a-b | French officers in the Guangzhou Bay abuse Chinese residents, report and comments by the Tung Wah Times. And a plea from the local residents to the Chinese authorities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093070 | 24093070 | |
28688 | 28688 | 1914-04-11 | 3 | a-b | The war in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24093069 | 24093069 | |
28699 | 28699 | 1914-04-11 | 6 | a-b | On the noble character of Kang Youwei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093074 | 24093074 | |
28701 | 28701 | 1914-04-11 | 7 | a-b | Australia news/ Chinese gardener is robbed in Darling Harbour, Sydney. A Chinese gardener is on trial for injuring his partner. Liner service charges to be increased between Australia and New Zealand. A man in New South Wales celebrates his 106th birthday. Bank in Queensland transports coins carefully. Tram fare increased in Sydney. Royal agricultural show in Sydney. Gibbs Bright & Co entertains students of the Sydney Chinese School and speakers include Lu Yijun, Ye Bingnan, Zhan Fu, Guo Shun, Liang Chuang, Chen Lin, Luo Run and Guo Jiexiu. Advertisement for Dr Williams' pink pills for pale people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093073 | 24093073 | |
28707 | 28707 | 1914-04-11 | 8 | a-b | Second part of proposal and regulations on the establishment of ping zheng yuan in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24093076 | 24093076 |
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]);