This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40600 | 40600 | 1923-10-27 | 6 | a-d | Chen Yixi, general manager of the Ningyang railway, issues a declaration on Sun Yatsen's new policy. | China | http://trove.nla.gov.au/newspaper/page/24094596 | 24094596 | |
40612 | 40612 | 1923-10-27 | 8 | a-d | Guangdong news/ Sun Yatsen is recommended as presidential candidate. Nanxiong county under different armies. Sun Yatsen's headquarters has a special meeting. Hotels and restaurants in Guangzhou are closed in protest against the new banquet tax. Protest in Guangzhou against the business registration fee. Pressgang in Guangzhou and the report. Cheng Tiandou buys his life at a high price. Police authority in Guangzhou bans communist propaganda. Sun Yatsen narrowly escapes an assassination. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094598 | 24094598 |
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]);