This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29622 | 29622 | 1915-01-23 | 7 | a-b | Chinese General Counsel notifies that no mail should be brought in according to the military law due to the European War. Australian troop fighting in a German-owned island return to Sydney. German officials captured by Australian troop are allowed to return home through Sydney. Australian coal is sold to Mexico. Sydney shops find some false gold coins. Shi Kuan (ppp) in New South Wales is stricken by a big hail. | Australia | http://trove.nla.gov.au/newspaper/page/24094699 | 24094699 | |
29623 | 29623 | 1915-01-23 | 7 | b | Mexico government decides to take back the Britain's right of managing petrol and coal in its country. | America | http://trove.nla.gov.au/newspaper/page/24094699 | 24094699 | |
29624 | 29624 | 1915-01-23 | 7 | b-c | Unexpected earthquake in Italy results in huge casualties. | Other... | http://trove.nla.gov.au/newspaper/page/24094699 | 24094699 | |
29625 | 29625 | 1915-01-23 | 7 | c | Austrian foreign minister resigned due to personal reasons. | Britain | http://trove.nla.gov.au/newspaper/page/24094699 | 24094699 | |
29626 | 29626 | 1915-01-23 | 7 | c | Italy, Begonia, Romania and Greek are to join the war to fight against Austria and Turkey. | Britain | http://trove.nla.gov.au/newspaper/page/24094699 | 24094699 | |
29627 | 29627 | 1915-01-23 | 7 | c | Social parties from various neutral countries hold a war mediation conference in Danmark. | Canada | http://trove.nla.gov.au/newspaper/page/24094699 | 24094699 |
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]);