This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21468 | 21468 | 1909-08-14 | 2 | a-b | First part of editorial by Tung Wah Times claims that Prince Su should resign as soon as possible. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802288 | 26802288 | |
21473 | 21473 | 1909-08-14 | 3 | a-b | Correspondence from Canada/ Copy of the regulation issued by Canadian authority to ban opium. | Canada | http://trove.nla.gov.au/newspaper/page/26802287 | 26802287 | |
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 | |
21494 | 21494 | 1909-08-14 | 7 | a-b | Earthquake in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802291 | 26802291 | |
21504 | 21504 | 1909-08-14 | 8 | a-b | British writer on Macao (territory, household, city wall), part VII. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802294 | 26802294 |
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]);