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 |
---|---|---|---|---|---|---|---|---|---|
30177 | 30177 | 1915-06-19 | 3 | b | Battle situation in west Europe between French and German troops. | France | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
30178 | 30178 | 1915-06-19 | 3 | b | Battle situation between Italian and Austrian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
30179 | 30179 | 1915-06-19 | 3 | b | German submarine sank two of British torpedo ships. | Britain | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
30180 | 30180 | 1915-06-19 | 3 | b | Italian submarine sank one of Austrian destroyers. | Britain | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
30181 | 30181 | 1915-06-19 | 3 | b | Two of German's injured submarines return to German port. | Britain | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
30182 | 30182 | 1915-06-19 | 3 | b | British government loosens age limit of recruiting soldiers. | Britain | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
30183 | 30183 | 1915-06-19 | 3 | b | American state secretary resigns as he opposes the president's policy to Germany. | America | http://trove.nla.gov.au/newspaper/page/24094880 | 24094880 | |
30189 | 30189 | 1915-06-19 | 6 | b | Zhen Xunyian's poems. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094885 | 24094885 | |
30191 | 30191 | 1915-06-19 | 7 | b | Statistics of British soldiers killed and wounded in the Europe War. | Britain | http://trove.nla.gov.au/newspaper/page/24094884 | 24094884 | |
30192 | 30192 | 1915-06-19 | 7 | b | Battle situation in east Europe between Russian and Austrian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094884 | 24094884 | |
30196 | 30196 | 1915-06-19 | 8 | b | Sa Zhenbin is inspecting navy troops in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094886 | 24094886 |
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]);