This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13451 | 13451 | 1904-07-02 | 3 | a | Korea has declared that all treaties with Russia will become null and void. | Britain | http://trove.nla.gov.au/newspaper/page/26800469 | 26800469 | |
13452 | 13452 | 1904-07-02 | 3 | a | Some Korean ministers try to prevent the Emperor from rebuilding the imperial palace that was burned to ashes not long ago. | Japan | http://trove.nla.gov.au/newspaper/page/26800469 | 26800469 | |
13453 | 13453 | 1904-07-02 | 3 | a | More people in Japan now have ranks of nobility. | Japan | http://trove.nla.gov.au/newspaper/page/26800469 | 26800469 | |
13454 | 13454 | 1904-07-02 | 3 | a | Italy manufactures a new cannon. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800469 | 26800469 | |
13456 | 13456 | 1904-07-02 | Suppl't | a | An article, published in Sydney's Sunday Times, says Chinese businesses in Sydney are now in crisis as many Chinese businessmen are leaving. The article is written after interviewing with Chen Xia and Sun Junchen, two Chinese businessmen in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/26800471 | 26800471 | |
13457 | 13457 | 1904-07-02 | Suppl't | a | A list of successful Guangdong candidates who have passed the imperial examination of 1904. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800471 | 26800471 | |
13458 | 13458 | 1904-07-02 | Suppl't | a | A stubborn scholar in Gaoyou, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/26800471 | 26800471 |
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]);