This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid ▲ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54104 | 54104 | 1934-04-28 | 6 | g | A notice issued by the Guangming Electrical Company in Shanghai on dividends of shares. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096000 | 24096000 | |
54103 | 54103 | 1934-04-28 | 6 | f | Australia news/ Sale of Australian flour in China is unsatisfactory. Chinese shop in Sydney robbed. A farewell notice issued by Guo Jianying. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096000 | 24096000 | |
54102 | 54102 | 1934-04-28 | 5 | b | Hong Kong government issues new regulations for registration of immigrants. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24095997 | 24095997 | |
54101 | 54101 | 1934-04-28 | 5 | b | Market of wheat flour in Guangzhou and Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24095997 | 24095997 | |
54100 | 54100 | 1934-04-28 | 5 | a | The bank set up by Manchurian state and its operations. | China | http://trove.nla.gov.au/newspaper/page/24095997 | 24095997 | |
54099 | 54099 | 1934-04-28 | 3 | f | Japanese help set up land administration office in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54098 | 54098 | 1934-04-28 | 3 | e | Japanese ambassador in China on the relations between the two countries. | China | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54097 | 54097 | 1934-04-28 | 3 | e | Japan saves oil for the future war. | Japan | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54096 | 54096 | 1934-04-28 | 3 | e | Manchurian state challenges Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54095 | 54095 | 1934-04-28 | 3 | c | The war between Russia and Japan is unavoidable. | Britain | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54094 | 54094 | 1934-04-28 | 3 | b | Xiao Focheng reports that Chinese immigrants are murdered in Thailand. | Other... | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54093 | 54093 | 1934-04-28 | 3 | a | The war clouds over Japan and Russia. | China | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54092 | 54092 | 1934-04-28 | 3 | a | Japanese military existence in north China. | China | http://trove.nla.gov.au/newspaper/page/24095993 | 24095993 | |
54091 | 54091 | 1934-04-28 | 2 | b | China news/ Economic Committee of the central government in Nanjing passes resolutions to the loans from America, and Song Ziwen reports to the Committee the loans from America. Third part of the draft constitution of the Republic of China. Sun Dianying's troops are besieged. | China | http://trove.nla.gov.au/newspaper/page/24095994 | 24095994 | |
54090 | 54090 | 1934-04-28 | 2 | a | Editorial on the traitors in China and the crisis followed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095994 | 24095994 |
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]);