This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51457 | 51457 | 1932-04-23 | 8 | a | Miscellaneous report on the resistance in Manchuria to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090782 | 24090782 | |
51458 | 51458 | 1932-04-23 | 8 | a | Both Soviet Russia and Japan are preparing for war. | Britain | http://trove.nla.gov.au/newspaper/page/24090782 | 24090782 | |
51459 | 51459 | 1932-04-23 | 8 | b | Resistance to Japanese invasion in China. Sun Lianzhong claims sick. Delegation of the League of Nations leaves Beijing for Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090782 | 24090782 | |
51460 | 51460 | 1932-04-23 | 8 | b | Australia news/ Robbery in Auckland, New Zealand. Chen Mingshu, Jiang Guanglai, Cai Tingkai and Fan Qiwu jointly write to the Chinese communities in Australia calling for more donations to the war of resistance in China. Fund-raising drama performance of the Chinese communities in Melbourne. Three Chinese sailors arrested in Adelaide for illegal entry. Tasmania and China compete each other in British market. Revenue of the Harbour Bridge in Sydney. Federal government and the NSW state government have different policy on passport application. The 26th meeting of the Chinese Progressive Association (hua qiao jiu guo hui) in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090782 | 24090782 | |
51461 | 51461 | 1932-04-23 | 8 | e | Chinese communities in New Zealand donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090782 | 24090782 |
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]);