This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32302 | 32302 | 1917-05-12 | 7 | a | A notice issued by Zeng Zongjian, Chinese Consul-General in Australia, on the Chinese government bonds. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095692 | 24095692 | |
32303 | 32303 | 1917-05-12 | 7 | a-b | Australia news/ Federal election in Australia and the result. Tariff income in the past ten months and statistics of each state. Income of postal service increases. Number of pensioners in Australia. Federal government awards mothers for childbirth. Amount of bank notes issued by Australian banks. Number of Australian soldiers who are killed in the World War I. Labour Party in Innisfail, Queensland, and their discrimination against Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095692 | 24095692 | |
32304 | 32304 | 1917-05-12 | 7 | b-c | A letter from Huangliangdu, Xiangshan county, on the bandit disasters there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095692 | 24095692 | |
32305 | 32305 | 1917-05-12 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095692 | 24095692 |
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]);