This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28410 | 28410 | 1914-01-17 | 2 | c | Chinese President Yuan Shikai comments on the national parliament. | China | http://trove.nla.gov.au/newspaper/page/24092961 | 24092961 | |
28427 | 28427 | 1914-01-17 | 6 | c | Chinese army general Sun Wu (Yaoqing) to tour overseas. | China | http://trove.nla.gov.au/newspaper/page/24092965 | 24092965 | |
28428 | 28428 | 1914-01-17 | 6 | c | Foreign debt of Persia and the statistics. | Other... | http://trove.nla.gov.au/newspaper/page/24092965 | 24092965 | |
28432 | 28432 | 1914-01-17 | 7 | c | Shi Zejing and Ren Xifen write to the Chinese Chamber of Commerce in Sydney and call for donations to the Red Cross in China in order to heal the wounded in the war, and a reply from the Chamber of Commerce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092964 | 24092964 | |
28433 | 28433 | 1914-01-17 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092964 | 24092964 | |
28437 | 28437 | 1914-01-17 | 8 | c | Chen Zhouying is to be executed for attempting to assassinate President Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/24092967 | 24092967 | |
28438 | 28438 | 1914-01-17 | 8 | c | Guangdong news/ Kang Youwei arrives Guangzhou with his mother's coffin. Guangdong authority seizes weapons smuggled for Chen Jiongming. | China | http://trove.nla.gov.au/newspaper/page/24092967 | 24092967 |
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]);