This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29818 | 29818 | 1915-03-27 | 3 | b | Statistics of business ships sunkened by German submarines in British sea. | Britain | http://trove.nla.gov.au/newspaper/page/24094784 | 24094784 | |
29819 | 29819 | 1915-03-27 | 3 | c | Miserable situation in Serbia which is troubled with shortage of doctors and medicine for wounded people. | Britain | http://trove.nla.gov.au/newspaper/page/24094784 | 24094784 | |
29821 | 29821 | 1915-03-27 | 3 | c-d | The Ally Army wins a number of battles in West Europe. | Britain | http://trove.nla.gov.au/newspaper/page/24094784 | 24094784 | |
29823 | 29823 | 1915-03-27 | 3 | d | The fleet of the Ally Army attack the Dong Ni Lou Shi (ppp) strait. | Britain | http://trove.nla.gov.au/newspaper/page/24094784 | 24094784 | |
29829 | 29829 | 1915-03-27 | 7 | b | People in Shanghai urge Chinese government to fight against Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29831 | 29831 | 1915-03-27 | 7 | b-c | Germany begins to use money of its secret war funds now. | Britain | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
29832 | 29832 | 1915-03-27 | 7 | c | Many lawyers in Britain join the army. | Britain | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 |
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]);