This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17055 | 17055 | 1907-03-09 | 6 | b | Help our compatriots. Chinese community in Australia donates to the famine victims in north Jiangsu and Anhui provinces. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801255 | 26801255 | |
17056 | 17056 | 1907-03-09 | 6 | b | Miscellaneous comment. National flower in China, Japan, France, America, Scotland, Spain and Canada. The United States after 100 years from now. An American rich man donates to the international peace conference. Silver can be turned into gold in America. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801255 | 26801255 | |
17072 | 17072 | 1907-03-09 | 7 | b | Miscellaneous. Industrial development in different countries. Diesel used for warship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801254 | 26801254 | |
17073 | 17073 | 1907-03-09 | 7 | b | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801254 | 26801254 | |
17074 | 17074 | 1907-03-09 | 7 | b | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801254 | 26801254 | |
17075 | 17075 | 1907-03-09 | 7 | b | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801254 | 26801254 | |
17077 | 17077 | 1907-03-09 | 8 | b | Novel. Erotic adventures of a reform hero. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801257 | 26801257 |
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]);