This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42413 | 42413 | 1924-12-06 | 8 | a-c | Guangdong news/ Deng Benyin issues a circular telegram against Sun Yatsen. Xiong Lue issues a circular telegram on the commercial chambers in Guangdong and their misconduct. Guangdong businessmen in Shanghai hate Sun Yatsen. Massacre in Guangzhou and Sun Yatsen's crimes. Guangdong army are urged to rebellion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100961 | 24100961 | |
42414 | 42414 | 1924-12-06 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100961 | 24100961 | |
42415 | 42415 | 1924-12-06 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100961 | 24100961 |
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]);