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 |
|---|---|---|---|---|---|---|---|---|---|
| 54006 | 54006 | 1934-03-31 | 2 | a | Jiang Jieshi talks about propriety, righteousness, honesty and a sense of shame. | China | http://trove.nla.gov.au/newspaper/page/24091581 | 24091581 | |
| 54007 | 54007 | 1934-03-31 | 2 | b | China news/ The Party leadership and Chinese politics. Ma Zhanshan cancels his trip to America. The strategic defeat of the 19th Route Army. Guangxi manufactures aircraft. Reform of provincial administration to be started in Jiangsu, Zhejiang, Hubei and Jiangxi province. Zhang Jia and his schedule in Mongolia. Battle between Wang Jingguo and Sun Dianying. | China | http://trove.nla.gov.au/newspaper/page/24091581 | 24091581 | |
| 54008 | 54008 | 1934-03-31 | 3 | a | Sun Dianying and his troops in Ningxia. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
| 54009 | 54009 | 1934-03-31 | 3 | a | Attempt to assassinate Ma Zhanshan. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
| 54010 | 54010 | 1934-03-31 | 3 | b | Japanese troops in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
| 54011 | 54011 | 1934-03-31 | 3 | b | Young man attempts to assassinate Japanese Prime Minister. | Japan | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
| 54012 | 54012 | 1934-03-31 | 3 | b | America and Germany may recognise the Manchurian government. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
| 54013 | 54013 | 1934-03-31 | 3 | c | Japan plans to cancel the provincial system in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
| 54014 | 54014 | 1934-03-31 | 3 | c | Comparison between Russian and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
| 54015 | 54015 | 1934-03-31 | 3 | e | Britain and Russia sign trade treaty. | Britain | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
| 54016 | 54016 | 1934-03-31 | 3 | f | Zhang Xueliang going to Wuhan. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
| 54017 | 54017 | 1934-03-31 | 5 | e | A delegation of Chinese businessmen from Hong Kong comes to visit Australia and the second part of the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091582 | 24091582 | |
| 54018 | 54018 | 1934-03-31 | 5 | f | A notice from Jiang Hua in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091582 | 24091582 | |
| 54019 | 54019 | 1934-03-31 | 7-8 | a-f | Guangdong news/ Relations between Guangzhou and Nanjing. Chen Jitang advises Cai Tingkai to go overseas. Cai Tingkai after leaving the army. Talks by Chen Mingshu. Opening of a judicial conference in Guangzhou. Education authority organises civil schooling in local counties. The Guangzhou between Western and Chinese New Years. Bandits in Zengcheng. Opium smuggling in Dongguan. | China | http://trove.nla.gov.au/newspaper/page/24091584 | 24091584 | |
| 54020 | 54020 | 1934-03-31 | 6 | a | Turkey borrows loans from China. | Other... | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
| 54021 | 54021 | 1934-03-31 | 6 | a | Miners on riots in Tangshan, Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
| 54022 | 54022 | 1934-03-31 | 6 | a | Military clashes between Russia and the Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
| 54023 | 54023 | 1934-03-31 | 6 | b | Typhoon in Japan and the damages. | Japan | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
| 54024 | 54024 | 1934-03-31 | 6 | b | Japan's demands from America. | Britain | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
| 54025 | 54025 | 1934-03-31 | 6 | e | The Philippines to become independent. | America | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
| 54026 | 54026 | 1934-03-31 | 6 | e | Brazil imposes strict restriction upon Japanese immigration. | Japan | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
| 54027 | 54027 | 1934-03-31 | 6 | e | Australia news/ Japan purchases wool from Australia. Australian army purchases cannons. Chinese man detained in Sydney for harbouring white girl. Two Chinese in fighting in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 |
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]);