Article Index

3 rows where date = "1923-10-27" and trove_id = 24094598

Filter results

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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 
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]);