This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33436 | 33436 | 1918-07-13 | 7 | b-c | Australia news/ New Zealand authority purchases wheat from Australia. New Zealanders like to drink. A Chinese man in injured in Sydney. Casualties of the Australian army in the World War I. Chinese government appoints Wang Ziyuan Deputy Consul-General and Gao Xing the Assistant Consul in Australia and they are entertained on arrival in Sydney by Guo Shun and Liu Guangfu. New Chinese consul to Samoa Lin Jizhang arrives Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097357 | 24097357 | |
33437 | 33437 | 1918-07-13 | 7 | c-d | Industrial briefs/ On land cultivation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097357 | 24097357 | |
33438 | 33438 | 1918-07-13 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097357 | 24097357 | |
33439 | 33439 | 1918-07-13 | 7 | d | Notice from the China-Australia Steamship Company in Sydney. And a notice issued by William J. L. Liu (Liu Guangfu) on the cargo services by the China-Australia Steamship Company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097357 | 24097357 |
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]);