This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17789 | 17789 | 1907-07-13 | 8 | a | A report prepared by Xu Rui, envoy of Chinese government, suggests setting up steamship company, bank and insurance company among overseas Chinese communities in order to protect the interest of China and overseas Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801402 | 26801402 | |
17790 | 17790 | 1907-07-13 | 8 | b-c | Second part of the survey on Tibet: local administration, temples, customs/ tariff offices, officials from the central government, administrative system, and army. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801402 | 26801402 | |
17791 | 17791 | 1907-07-13 | 8 | c | Lying, selected from Commercial Daily (shang bao) in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26801402 | 26801402 | |
17792 | 17792 | 1907-07-13 | 8 | c-d | Jokes. A verbal battle between drinking and smoking. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801402 | 26801402 |
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]);