This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21486 | 21486 | 1909-08-14 | 6 | a-b | Correspondence from Beijing/ Duan Fang might be promoted. The death of Yang Shixiang and an analysis. Many ministers are ill in the court. Newly appointed Guangdong governor general Yuan Shuxun and his story. Prince Regent controls everything in the court. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802292 | 26802292 | |
21487 | 21487 | 1909-08-14 | 6 | b | Foshan authority reaches an agreement with the China Navigation Co Ltd to solve the murder case. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802292 | 26802292 | |
21488 | 21488 | 1909-08-14 | 6 | b | Chinese government withdraws its opposition to Japan's plan of railway construction from Fengtian to Andong. | Britain | http://trove.nla.gov.au/newspaper/page/26802292 | 26802292 | |
21489 | 21489 | 1909-08-14 | 6 | b | Chinese authority and British businessman have reached agreement on the Tongguanshan mine in Anhui province. | Japan | http://trove.nla.gov.au/newspaper/page/26802292 | 26802292 | |
21490 | 21490 | 1909-08-14 | 6 | b-c | Story of the Boxer Movement and foreign troops in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802292 | 26802292 | |
21491 | 21491 | 1909-08-14 | 6 | c | Japan's conspiracy in Manchuria. | Russia | http://trove.nla.gov.au/newspaper/page/26802292 | 26802292 | |
21492 | 21492 | 1909-08-14 | 6 | d | Sydney market report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802292 | 26802292 |
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]);