This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32509 | 32509 | 1917-07-28 | 7 | a | Tung Wah Times passes on messages from Zeng Zongjian, Chinese Consul-General in Australia, which says that Feng Guozhang is now Chinese president, Duan Qirui the premier, and that Zhang Xun has surrendered himself. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095780 | 24095780 | |
32510 | 32510 | 1917-07-28 | 7 | a | Chinese navy is against the Cabinet under Duan Qirui. | Britain | http://trove.nla.gov.au/newspaper/page/24095780 | 24095780 | |
32511 | 32511 | 1917-07-28 | 7 | a-b | Australia news/ Australians donate to French refugees on their National Day. Police in Sydney raid international union office. Statistics on casualties of the Australian troops in the World War I. Price of tram ticket is going up in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095780 | 24095780 | |
32512 | 32512 | 1917-07-28 | 7 | b-c | Further report on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095780 | 24095780 | |
32513 | 32513 | 1917-07-28 | 7 | c | Chaos in the capital of Russia. | America | http://trove.nla.gov.au/newspaper/page/24095780 | 24095780 | |
32514 | 32514 | 1917-07-28 | 7 | c | Thailand declares war with Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24095780 | 24095780 | |
32515 | 32515 | 1917-07-28 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095780 | 24095780 |
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]);