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 |
---|---|---|---|---|---|---|---|---|---|
50900 | 50900 | 1931-11-28 | 2 | b | On the resistance to Japanese invasion of Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090613 | 24090613 | |
50910 | 50910 | 1931-11-28 | 6 | b | A notice issued by Cai Chang says The Sun Company in Hong Kong to set up a branch company in Shanghai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090617 | 24090617 | |
50912 | 50912 | 1931-11-28 | 7 | a | Chinese communities in Sydney gather and mourn the death of countrymen in Manchuria during the Japanese invasion, and collection of the memorial writings. Chinese communities in Melbourne donate to the Saving China Military Funds. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090616 | 24090616 | |
50918 | 50918 | 1931-11-28 | 8 | c | Miscellaneous report on Japanese invasion of Manchuria. Gu Weijun is now the foreign minister of Chinese government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090619 | 24090619 | |
50919 | 50919 | 1931-11-28 | 8 | e | The Chinese Chamber of Commerce of New South Wales acknowledges receipt of donations to the flooding areas in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090619 | 24090619 |
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]);