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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
54009 | 54009 | 1934-03-31 | 3 | a | Attempt to assassinate Ma Zhanshan. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
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 | |
54026 | 54026 | 1934-03-31 | 6 | e | Brazil imposes strict restriction upon Japanese immigration. | Japan | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
54015 | 54015 | 1934-03-31 | 3 | e | Britain and Russia sign trade treaty. | Britain | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
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 | |
54014 | 54014 | 1934-03-31 | 3 | c | Comparison between Russian and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
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 | |
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 | |
54024 | 54024 | 1934-03-31 | 6 | b | Japan's demands from America. | Britain | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
54010 | 54010 | 1934-03-31 | 3 | b | Japanese troops in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
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 | |
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 | |
54021 | 54021 | 1934-03-31 | 6 | a | Miners on riots in Tangshan, Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
54008 | 54008 | 1934-03-31 | 3 | a | Sun Dianying and his troops in Ningxia. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 | |
54025 | 54025 | 1934-03-31 | 6 | e | The Philippines to become independent. | America | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
54020 | 54020 | 1934-03-31 | 6 | a | Turkey borrows loans from China. | Other... | 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 | |
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 | |
54016 | 54016 | 1934-03-31 | 3 | f | Zhang Xueliang going to Wuhan. | China | http://trove.nla.gov.au/newspaper/page/24091580 | 24091580 |
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]);