This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46832 | 46832 | 1928-03-17 | 2 | b | First part of the comments on the roving banditry strategy of the Chinese Communist Party. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098728 | 24098728 | |
46836 | 46836 | 1928-03-17 | 3 | b | Many countries around the world have abolished the capital punishment, and the response of China. | Britain | http://trove.nla.gov.au/newspaper/page/24098727 | 24098727 | |
46837 | 46837 | 1928-03-17 | 3 | b | Wang Zhengting is appointed foreign minister of the Nationalist government in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098727 | 24098727 | |
46848 | 46848 | 1928-03-17 | 6 | b | The Communist disasters in Hainan island. | China | http://trove.nla.gov.au/newspaper/page/24098732 | 24098732 | |
46856 | 46856 | 1928-03-17 | 7 | b | Australia news/ A priest in Melbourne is on trial for murder of his wife. Bandits are shot dead in Manly, Sydney. Chinese man is robbed in Sydney on his way to deposit in the bank. A British pilot arrives Sydney and the welcome ceremony. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098731 | 24098731 |
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]);