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 |
|---|---|---|---|---|---|---|---|---|---|
| 56480 | 56480 | 1936-12-12 | 2 | b | Editorial calls for saving of the peace. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097093 | 24097093 | |
| 56481 | 56481 | 1936-12-12 | 2 | c | China news/ Birthday celebration in Nanjing for Jiang Jieshi. Duan Qirui dies in Shanghai and his will. Foreign minister Zhang Qun meets Japanese envoy in Nanjing. More than 200 Japanese soldiers are deserted. Song Zheyuan seeks to resign as governor of Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24097093 | 24097093 | |
| 56482 | 56482 | 1936-12-12 | 3 | a | Suffering of the Chinese communities in the Philippines. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097092 | 24097092 | |
| 56483 | 56483 | 1936-12-12 | 3 | a | British Labour Party leader questions the government on its Far East policy. | Britain | http://trove.nla.gov.au/newspaper/page/24097092 | 24097092 | |
| 56484 | 56484 | 1936-12-12 | 3 | a | Relations between Britain and Japan deteriorate. | Britain | http://trove.nla.gov.au/newspaper/page/24097092 | 24097092 | |
| 56485 | 56485 | 1936-12-12 | 3 | b | Germany will not recognise Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24097092 | 24097092 | |
| 56486 | 56486 | 1936-12-12 | 3 | b | Japanese tank in Beijing kills Chinese girl student and the report. | China | http://trove.nla.gov.au/newspaper/page/24097092 | 24097092 | |
| 56487 | 56487 | 1936-12-12 | 6-7 | a-d | Guangdong news/ Provincial government finalises new military budget. Song Ziwen arrives Guangzhou for the reopening of the Bank of Guangdong. Institute to be set up in memory of Hu Hanmin. Japanese warships in Hainan island. County authorities are ordered to complete the road construction. Provincial government to clear public properties. Collection of personal income tax in Guangdong and Guangxi. Overseas Chinese communities are remitting more money back to China and the statistics. Peasants in Zengcheng request to abolish exorbitant taxes. Dongguan county government repeats its ban on opium smoking. | China | http://trove.nla.gov.au/newspaper/page/24097097 | 24097097 | |
| 56488 | 56488 | 1936-12-12 | 8 | a | Japanese propaganda in north China. | China | http://trove.nla.gov.au/newspaper/page/24097099 | 24097099 | |
| 56489 | 56489 | 1936-12-12 | 8 | b | American President Roosevelt speaks at a conference in South America. | America | http://trove.nla.gov.au/newspaper/page/24097099 | 24097099 | |
| 56490 | 56490 | 1936-12-12 | 8 | c | Japanese attitude towards Britain. | Japan | http://trove.nla.gov.au/newspaper/page/24097099 | 24097099 | |
| 56491 | 56491 | 1936-12-12 | 8 | c | Japanese sailors land in Qingdao, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24097099 | 24097099 | |
| 56492 | 56492 | 1936-12-12 | 8 | f | Australia news/ Chinese market gardener Li He is murdered and a further report. Victorian State Government prepares to send 99 old Chinese men back to China and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097099 | 24097099 | |
| 56493 | 56493 | 1936-12-12 | 8 | g | A notice issued by the Chinese Chamber of Commerce in NSW on the arrival of Luo Jieshi and his inspection on the New Life Movement in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097099 | 24097099 |
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]);