This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54543 | 54543 | 1934-09-29 | 2 | a | Two notices issued by the Chinese Chamber of Commerce in NSW. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54544 | 54544 | 1934-09-29 | 2 | a | Editorial in praise of the Chinese troops in Manchuria and their resistance to Japanese invasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54545 | 54545 | 1934-09-29 | 2 | c | China news/ Liaison between Chinese troops in Manchuria. Battles in Tanggu near Tianjin. Manoeuvre of foreign troops in north China. Japanese and Korean people are selling drugs in the war zones in north China. Japanese goods in the war zones of China. Japanese fleet near Tanggu. | China | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54546 | 54546 | 1934-09-29 | 2 | d | British government and the air defence in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54547 | 54547 | 1934-09-29 | 2 | d | Liu Xiang resigns suddenly. | China | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54548 | 54548 | 1934-09-29 | 2 | e | Hails after serious drought in Hubei province, China. | China | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54549 | 54549 | 1934-09-29 | 2 | e | Possible famine in Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54550 | 54550 | 1934-09-29 | 2 | f | Both Japan and Russia are preparing for war. | China | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 |
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]);