This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54427 | 54427 | 1934-08-18 | 3 | a | Huang Yin's attitude is unclear. | China | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54428 | 54428 | 1934-08-18 | 3 | a | Plain clothes spies in Shenyang and bomb explosion. Agricultural production in north China. Japanese military officer tries to steal classified documents from Russian consulate. Chinese volunteer armies in Manchuria and their resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54429 | 54429 | 1934-08-18 | 3 | c | Floods in Japan and riots of the refugees. | Japan | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54430 | 54430 | 1934-08-18 | 3 | c | American navy and their exercise in the Pacific. | Japan | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54431 | 54431 | 1934-08-18 | 3 | b | Cai Tingkai now in Belgium. | China | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54432 | 54432 | 1934-08-18 | 3 | c | Cao Rulin and Wang Jitang may surrender themselves. | China | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 |
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]);