This data as json, CSV (advanced)
Suggested facets: page, column, 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 | |
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 |
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]);