This data as json, CSV (advanced)
Suggested facets: 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 |
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]);