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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 54092 | 54092 | 1934-04-28 | 3 | a | Japanese military existence in north China. | China | 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 | |
| 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 | |
| 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 | |
| 54096 | 54096 | 1934-04-28 | 3 | e | Manchurian state challenges Soviet Russia. | 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 |
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]);