This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25122 | 25122 | 1911-10-14 | 2 | a-b | Critising ridiculous currency of the revolutionary party | The currency of Republic of China issued by Sun Yatsen is in fact that the revolutionaries are cheating people for money. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091956 | 24091956 |
25134 | 25134 | 1911-10-14 | 3 | b | New riots in Mexico | New riots occurs in Mexico and compensations for Chinese casualties are said to be vanished. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091955 | 24091955 |
25142 | 25142 | 1911-10-14 | 6 | b | Right loss in Mongolia and Man Zhou | Russian troops frequently interfere in Mongolia and Man Zhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091962 | 24091962 |
25145 | 25145 | 1911-10-14 | 6 | b | An Yi Ren Charity's donation name list | Number of donation and name list of donators to the Charity. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091962 | 24091962 |
25146 | 25146 | 1911-10-14 | 7 | a | Call on donations for Anhui flooding | Sydney Empire Constitutional Association calls on donations for Anhui flooding. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091961 | 24091961 |
25153 | 25153 | 1911-10-14 | 7 | c | Letter from a reader | Ming Yi Tang is not to get involved with revolutionaries' matter. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091961 | 24091961 |
25156 | 25156 | 1911-10-14 | 8 | b-c | Four questions for the revolutionary East Warning newspaper | Criticising the revolutionary logic of starting violent revolution in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091964 | 24091964 |
25157 | 25157 | 1911-10-14 | 8 | c-d | Freedom of prostitution in Japan | Criticising the freedom of prostitution in Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091964 | 24091964 |
25158 | 25158 | 1911-10-14 | suppl | a | The seventh attack on East Warning newspaper | Criticising racism revolution of the revolutionary party. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091963 | 24091963 |
25159 | 25159 | 1911-10-14 | suppl | b | Strange answers of East Warning newspaper | Criticising East Warning newspaper's ridiculous revolutionary views. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091963 | 24091963 |
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]);