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 |
---|---|---|---|---|---|---|---|---|---|
12093 | 12093 | 1903-08-08 | 2 | a | First part of an article claiming that it is not the Russian who conquered the Manchuria. It is the Manchu dynasty is responsible for the demise of Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800269 | 26800269 | |
12103 | 12103 | 1903-08-08 | 3 | a | Government's effort to suppress bandits in Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 | |
12104 | 12104 | 1903-08-08 | 3 | a | Raining beans seen in Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 | |
12105 | 12105 | 1903-08-08 | 3 | a | Mr Morgan is the richest man in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 | |
12106 | 12106 | 1903-08-08 | 3 | a | Emperor of Korea is likely to enter into an alliance with Russia. | Other... | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 | |
12107 | 12107 | 1903-08-08 | 3 | a | A kind of sugar tree has been found in South America. | Other... | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 | |
12108 | 12108 | 1903-08-08 | 3 | a | Some Chinese in the Philippines apply for return certificates with forged documents. | Other... | http://trove.nla.gov.au/newspaper/page/26800268 | 26800268 |
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]);