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 |
---|---|---|---|---|---|---|---|---|---|
29951 | 29951 | 1915-04-24 | 2 | b | Comment on current event: China's Policy of Keeping State's Secrets. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094817 | 24094817 | |
29957 | 29957 | 1915-04-24 | 3 | b | Battle situation between British, French and German troops in west Europe. | France | http://trove.nla.gov.au/newspaper/page/24094816 | 24094816 | |
29958 | 29958 | 1915-04-24 | 3 | b | The rumours of navy battles in North British Sea. | Other... | http://trove.nla.gov.au/newspaper/page/24094816 | 24094816 | |
29959 | 29959 | 1915-04-24 | 3 | b | British parliament proposes that strong wines should be traded specially. | Britain | http://trove.nla.gov.au/newspaper/page/24094816 | 24094816 | |
29966 | 29966 | 1915-04-24 | 6 | b | New miscellany/ Song Wechen proposes to set up a national bank. It is said to have some important personnel change in Beijing. Tian Wenlie cables to the government that Henan is of rice crisis. Anhui and Zhejiang's police chiefs return to their posts. Guangdong is to allow gambling business. | China | http://trove.nla.gov.au/newspaper/page/24094821 | 24094821 | |
29974 | 29974 | 1915-04-24 | 8 | b | Brief biography of Huang Xing by the central government (to be continued). | China | http://trove.nla.gov.au/newspaper/page/24094823 | 24094823 |
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]);