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 |
---|---|---|---|---|---|---|---|---|---|
30630 | 30630 | 1915-10-30 | 3 | b | Statistics of British business ships lost in the Europe War. | Britain | http://trove.nla.gov.au/newspaper/page/24095034 | 24095034 | |
30631 | 30631 | 1915-10-30 | 3 | b | Battle situation in east Europe between Russian and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24095034 | 24095034 | |
30632 | 30632 | 1915-10-30 | 3 | b | Battle situation in west Europe between French and German troops. | France | http://trove.nla.gov.au/newspaper/page/24095034 | 24095034 | |
30642 | 30642 | 1915-10-30 | 6 | b | Beijing news/Li Ziyun, a businessman in Hubei, plans to set up China's largest textile plant. Chinese government plans to promote education for civilians. Deng Sheng who involves in Chen Shen's case is sentenced to death. | China | http://trove.nla.gov.au/newspaper/page/24095039 | 24095039 | |
30644 | 30644 | 1915-10-30 | 7 | b | King of Egypt promises to send troops to fight against Turkey. | Britain | http://trove.nla.gov.au/newspaper/page/24095038 | 24095038 | |
30645 | 30645 | 1915-10-30 | 7 | b | A German warship in Mediterranean Sea is sunken by a British submarine. | Britain | http://trove.nla.gov.au/newspaper/page/24095038 | 24095038 | |
30646 | 30646 | 1915-10-30 | 7 | b | Battle situation in Serbia between the Ally army and German-Austrian troops. | Britain | http://trove.nla.gov.au/newspaper/page/24095038 | 24095038 | |
30647 | 30647 | 1915-10-30 | 7 | b | Chinese businessmen are negotiating with American businessmen for the joint shipping company. | America | http://trove.nla.gov.au/newspaper/page/24095038 | 24095038 |
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]);