This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30434 | 30434 | 1915-09-04 | 7 | a-b | Australia news/Notice of Australian general procurator on investigating animals raised by people for the Europe War purpose. Statistics of soldier to be enrolled in various states in Australia. An Australian made destroyer enters the sea to serve the navy in Sydney. A woman from Newcastle is found suffering small pots. People in Freemantle in South Australia celebrate Ally's victory in Li Jia (ppp) strait and destroy German people's properties. | Australia | http://trove.nla.gov.au/newspaper/page/24094974 | 24094974 | |
30435 | 30435 | 1915-09-04 | 7 | b | Germany refuses to admit its heavy loss in navy fight with Russia in Li Jia (ppp) Strait. | Germany | http://trove.nla.gov.au/newspaper/page/24094974 | 24094974 | |
30436 | 30436 | 1915-09-04 | 7 | b | German envoy in America tells American State Secretary that German submarines are to notify transporting ships of warring nations before attacking them. | America | http://trove.nla.gov.au/newspaper/page/24094974 | 24094974 | |
30437 | 30437 | 1915-09-04 | 7 | b | British fleets attack German coast cities. | Britain | http://trove.nla.gov.au/newspaper/page/24094974 | 24094974 | |
30438 | 30438 | 1915-09-04 | 7 | b | Battle situation between Italian and Austrian troops. | Other... | http://trove.nla.gov.au/newspaper/page/24094974 | 24094974 | |
30439 | 30439 | 1915-09-04 | 7 | b | Battle situation in west Europe between British, French and German troops. | Britain | http://trove.nla.gov.au/newspaper/page/24094974 | 24094974 | |
30440 | 30440 | 1915-09-04 | 7 | b-c | Battle situation in west Europe between Russian and German troops. | Britain | http://trove.nla.gov.au/newspaper/page/24094974 | 24094974 |
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]);