This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
40613 | 40613 | 1923-10-27 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094598 | 24094598 | |
40614 | 40614 | 1923-10-27 | 8 | e | Liner timetable. | 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]);