This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51888 | 51888 | 1932-09-10 | 2 | f | Protest issued Chinese foreign ministry to Japanese authority. | China | http://trove.nla.gov.au/newspaper/page/24090938 | 24090938 | |
51889 | 51889 | 1932-09-10 | 2 | f | Chinese volunteer armies in Manchuria fighting Japanese invaders. Japanese troops are leaving Korea for Manchuria. Army commanders in north China to issue a declaration. Ma Zhanshan leads his troops to Hailun. Chinese Ministry of Railway to borrow foreign loans to complete the Guangzhou-Hankou railway. Japanese warship protect their merchant ship in Shanghai. Guo Zhongxing on the way to fight Japanese in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090938 | 24090938 | |
51906 | 51906 | 1932-09-10 | 8 | f | Delegation of the League of Nations leaves China. | China | http://trove.nla.gov.au/newspaper/page/24090944 | 24090944 | |
51907 | 51907 | 1932-09-10 | 8 | f | Police in Shanghai arrest Japanese sailors. | China | http://trove.nla.gov.au/newspaper/page/24090944 | 24090944 | |
51908 | 51908 | 1932-09-10 | 8 | f | Australia news/ Chinese communities in Sydney welcome Zhao Yu and the report. Federal government relaxes its control on immigration and imports. Chinese man on trial in Sydney for fake bank notes. Four Chinese man and women are punished in Sydney for opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090944 | 24090944 |
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]);