This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16585 | 16585 | 1906-12-15 | 5 | a | Notice from the Chinese Empire Reform Association in Sydney regarding recruitment of new members, membership fees and contact details. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801162 | 26801162 | |
16586 | 16586 | 1906-12-15 | 5 | a | Tung Wah Times calls for purchase of shares in the Mexico bank, official bank to be opened for the Chinese Empire Reform Association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801162 | 26801162 | |
16587 | 16587 | 1906-12-15 | 5 | a-b | An essay advocates people's participation in government and political affairs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801162 | 26801162 | |
16588 | 16588 | 1906-12-15 | 5 | b | Famine in China and report on the casualties. Mayors of London, Paris, New York and Berlin are urged to organise donations. And comments by Tung Wah Times. | Britain | http://trove.nla.gov.au/newspaper/page/26801162 | 26801162 | |
16589 | 16589 | 1906-12-15 | 5 | b-c | Jokes. New folk song on constitutional reform. Preserve the quintessence of China. A notice from whoremonger association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801162 | 26801162 | |
16590 | 16590 | 1906-12-15 | 5 | c | Novel. Trial of bandit. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801162 | 26801162 | |
16591 | 16591 | 1906-12-15 | 5 | c | Special notice. A notice from the Tung Wah Times says prices of overseas newspapers, that are available from the Tung Wah Times, will go up due to the fluctuations in the exchange rate. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801162 | 26801162 |
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]);