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 |
---|---|---|---|---|---|---|---|---|---|
51373 | 51373 | 1932-04-09 | 2 | a | Chinese societies & associations in Sydney jointly call for donations to the war of resistance in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090760 | 24090760 | |
51374 | 51374 | 1932-04-09 | 2 | b | Editorial by Tung Wah Times on the efforts in China to eliminate the communists during the national crisis. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090760 | 24090760 | |
51390 | 51390 | 1932-04-09 | 5 | e | Chinese communities in Sydney donate to the war of resistance to Japanese invasion and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090761 | 24090761 | |
51405 | 51405 | 1932-04-09 | 8 | c | Australia news/ Li Huitang, coach of the soccer team in Hong Kong, seeks to visit Australia after their match in Java. The 24th meeting of the Chinese Progressive Association. Passenger claim that their jewellery are stolen in Auckland. The Sydney Chinese Progressive Association urges the Nanjing government to prepare for a war with Japanese. Heavy rains in Victoria and the damages. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090766 | 24090766 | |
51406 | 51406 | 1932-04-09 | 8 | e | Chinese communities in Australia and New Zealand donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090766 | 24090766 |
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]);