This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51854 | 51854 | 1932-08-27 | 8 | a | Wang Jingwei in Nanjing can not find a successor. | China | http://trove.nla.gov.au/newspaper/page/24090927 | 24090927 | |
51855 | 51855 | 1932-08-27 | 8 | a | Rehe in crisis. Japanese troops in Tianjin. Zhang Xueliang's request for resignation is approved. Wang Jingwei is determined to leave. Chinese foreign minister Luo Wengan protest against the Japanese ambassador to Manchuria. Manchurian state government protest against the Russian troops. Floods of the Songhuajiang River. More new on the fighting of Chinese troops in Manchuria with Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090927 | 24090927 | |
51856 | 51856 | 1932-08-27 | 8 | e | Five people arrested in Japan for attempt to assassinate the Prime Minister. | Japan | http://trove.nla.gov.au/newspaper/page/24090927 | 24090927 | |
51857 | 51857 | 1932-08-27 | 8 | e | Australia news/ A talk by the Chinese Consul-General in Australia Chen Weipin. Two Chinese men are arrested in Sydney for opium smuggling. NSW state government promulgate new traffic regulations. Exhibition of Australian products in Hong Kong is postponed. A Chinese man is penalised in Sydney for tax evasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090927 | 24090927 |
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]);