This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30907 | 30907 | 1916-01-22 | 3 | a | Overseas Chinese in Singapore cables to ask consul general Tang Caizhi to remain in office. | Singapore | http://trove.nla.gov.au/newspaper/page/24095117 | 24095117 | |
30908 | 30908 | 1916-01-22 | 3 | a | Yuan Shikai is to come to throne as planned. | Britain | http://trove.nla.gov.au/newspaper/page/24095117 | 24095117 | |
30925 | 30925 | 1916-01-22 | 7 | a | Australia news/ Notice of Chinese consul general on changing new passports. An European lawyer replies that Australian government can't compel Chinese people to join the army according to international law. Statistics of Australian soldiers killed and wounded in the Europe War. Price of sugar rises in Australia. Bush fire in New South Wales results in heavy loss for agriculture. | Australia | http://trove.nla.gov.au/newspaper/page/24095121 | 24095121 |
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]);