This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29793 | 29793 | 1915-03-20 | 7 | a | Australia news/ An European man Wu Dan Lou (nnn) aged 100 years old died in Sydney. A soldier in Sydney is charged for his swear after being drunk. Greek consul in Melbourne notifies that all previous Greek soldiers in Victoria to register. Australian government is to provide relief funds for poor people from the enemy countries. | Australia | http://trove.nla.gov.au/newspaper/page/24094780 | 24094780 | |
29804 | 29804 | 1915-03-20 | 8 | a | Provisions of China's Business and Trade Association. | Australia | http://trove.nla.gov.au/newspaper/page/24094783 | 24094783 |
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]);