This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31438 | 31438 | 1916-07-29 | 3 | a-b | General Chamber of Commerce in Shanghai seeks to maintain stability of the Bank of China and the Bank of Communications. | China | http://trove.nla.gov.au/newspaper/page/24095346 | 24095346 | |
31442 | 31442 | 1916-07-29 | 6 | a-b | Second part of the report prepared by Zeng Zongjian, Chinese Consul-General in Australia, on the sale of China products in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095351 | 24095351 | |
31445 | 31445 | 1916-07-29 | 7 | a-b | Australia news/ Federal audition of the building industry in Adelaide. German detainees in Australia dig tunnel and escape. Australian troops and their fighting in France. British commander reports the fighting of Australian army in the World War I. | Australia | http://trove.nla.gov.au/newspaper/page/24095350 | 24095350 | |
31449 | 31449 | 1916-07-29 | 8 | a-b | Beijing news/ Liang Qichao arrives Shanghai. Huang Peisong arrive Xiamen (Amoy) from Beijing. Cruelty of the Changshu county magistrate in Jiangsu province. Murderer of the Haizhu case escapes to Beijing. Britain, France, Japan and Russia to protect the Republic system in China. Sign of foreign management of Chinese finance. Wang Jitang in collaboration with bandits. | China | http://trove.nla.gov.au/newspaper/page/24095353 | 24095353 |
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]);