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 |
---|---|---|---|---|---|---|---|---|---|
51614 | 51614 | 1932-06-18 | 2 | a | Yuguan in Suiyuan province in crisis. | China | http://trove.nla.gov.au/newspaper/page/24090840 | 24090840 | |
51615 | 51615 | 1932-06-18 | 2 | c | Japanese troops are withdrawing from the war zones near Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090840 | 24090840 | |
51616 | 51616 | 1932-06-18 | 2 | d | Zhang Huichang secures funds from overseas Chinese communities to purchase war planes. | China | http://trove.nla.gov.au/newspaper/page/24090840 | 24090840 | |
51617 | 51617 | 1932-06-18 | 2 | e | Chinese police take over Zhabei in Shanghai. Japanese troops are approaching Yuguan. Report prepared by the delegation of the League of Nations on the Japanese invasion of China. Wang Jingwei, Jiang Jieshi and Sun Ke may meet to discuss the current situation. | China | http://trove.nla.gov.au/newspaper/page/24090840 | 24090840 | |
51618 | 51618 | 1932-06-18 | 3 | a | The Saving China Association in Shanghai and their declaration. | China | http://trove.nla.gov.au/newspaper/page/24090839 | 24090839 | |
51619 | 51619 | 1932-06-18 | 3 | c | Wu Peifu delivers a speech on the martial arts. | China | http://trove.nla.gov.au/newspaper/page/24090839 | 24090839 | |
51620 | 51620 | 1932-06-18 | 3 | e | Secret agreement between the Manchurian state and Japanese. | China | http://trove.nla.gov.au/newspaper/page/24090839 | 24090839 | |
51621 | 51621 | 1932-06-18 | 5 | c | Chinese communities in Newcastle and Melbourne donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090841 | 24090841 | |
51622 | 51622 | 1932-06-18 | 6-7 | a-d | Guangdong news/ Ding Jixu leads four war planes to Guangzhou. Ma Zhanshan's telegram arrives Guangdong. Circular telegram issued by Chen Ce. The truce in Shanghai and the influence in Guangdong. Guangdong navy and the coastal defence. Circular telegram issued by the Guangdong branch of the Nationalist Party. Peng Chuli is executed for profiteering. Guangdong branch questions the central authority of the Nationalist Party. | China | http://trove.nla.gov.au/newspaper/page/24090844 | 24090844 | |
51623 | 51623 | 1932-06-18 | 8 | a | Famine in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51624 | 51624 | 1932-06-18 | 8 | a | Resistance in Manchuria to the Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51625 | 51625 | 1932-06-18 | 8 | a | Japanese control of the Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51626 | 51626 | 1932-06-18 | 8 | b | The Nanjing government to resume diplomatic relations with Russia. | China | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51627 | 51627 | 1932-06-18 | 8 | b | Protest in Britain against the income tax. | Britain | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51628 | 51628 | 1932-06-18 | 8 | b | News from India. | Other... | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51629 | 51629 | 1932-06-18 | 8 | c | Questions in the British House of Commons. | Britain | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 | |
51630 | 51630 | 1932-06-18 | 8 | c | Australia news/ Banks to cut the interest rate. Bank robbery in Queensland. Another suicide in the Sydney Harbour Bridge. The 32nd meeting of the Chinese Progressive Association in Sydney. Old Chinese man dies in Melbourne with huge assets. Huang Huazhi dies in NSW. Disputes over the NSW state politics. Tobacco import in Sydney. Election result in New South Wales. Clash between civilians and police in Newcastle. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090845 | 24090845 |
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]);