This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
51923 | 51923 | 1932-09-17 | 8 | a | British tourists are kidnapped in Niuzhuang, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24090952 | 24090952 | |
51924 | 51924 | 1932-09-17 | 8 | a | Chinese foreign minister Luo Wengan meets new Japanese ambassador. | China | http://trove.nla.gov.au/newspaper/page/24090952 | 24090952 | |
51925 | 51925 | 1932-09-17 | 8 | a | Troops of the puppet Manchurian state and their mutiny. | China | http://trove.nla.gov.au/newspaper/page/24090952 | 24090952 | |
51926 | 51926 | 1932-09-17 | 8 | b | Troops of Rehe and Chaha'er unit to fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090952 | 24090952 | |
51927 | 51927 | 1932-09-17 | 8 | b | Chinese volunteer army in Manchuria and their fighting with Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090952 | 24090952 | |
51928 | 51928 | 1932-09-17 | 8 | f | Australia news/ Another suicide on the Sydney Harbour Bridge. Three Chinese men in Sydney on trial for fake bank notes. Tobacco growers harvest huge profit. Two children in Sydney are drowned while swimming. Zhao Yu, of the zhi gong tang in Shanghai, delivers a speech to the Chinese communities in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090952 | 24090952 |
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]);