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 |
---|---|---|---|---|---|---|---|---|---|
54025 | 54025 | 1934-03-31 | 6 | e | The Philippines to become independent. | America | 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 | |
54024 | 54024 | 1934-03-31 | 6 | b | Japan's demands from America. | Britain | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
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 | |
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 | |
54016 | 54016 | 1934-03-31 | 3 | f | Zhang Xueliang going to Wuhan. | 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 | |
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 | |
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 | |
54023 | 54023 | 1934-03-31 | 6 | b | Typhoon in Japan and the damages. | Japan | 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 | |
54020 | 54020 | 1934-03-31 | 6 | a | Turkey borrows loans from China. | Other... | http://trove.nla.gov.au/newspaper/page/24091585 | 24091585 | |
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 | |
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]);