This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 41715 | 41715 | 1924-06-21 | 3 | a-b | Wu Peifu prepares to backup Guangdong and the report. | China | http://trove.nla.gov.au/newspaper/page/24100760 | 24100760 | |
| 41716 | 41716 | 1924-06-21 | 3 | b-c | Tang Longxiang is wanted by the Guangdong provincial authority for his anti-Guomindang activities in Australia. The order is issued on recommendation by Guomindang members in Australia Huang Yougong, Huang Zheng, Chen Huangqiang, Zhao San, and Liang Aiguo. Tang used to be chief-editor of the Gong Bao (Bulletin) in Sydney. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100760 | 24100760 | |
| 41717 | 41717 | 1924-06-21 | 3 | c-d | Foreign newspapers report the illness of Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100760 | 24100760 | |
| 41718 | 41718 | 1924-06-21 | 3 | e | Bandits in New York hijack customs truck. | America | http://trove.nla.gov.au/newspaper/page/24100760 | 24100760 | |
| 41719 | 41719 | 1924-06-21 | 3 | e | A Japanese ship is stranded near the Hainan island. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100760 | 24100760 | |
| 41720 | 41720 | 1924-06-21 | 3 | e | Zhang Zuolin seeks to govern outer Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24100760 | 24100760 | |
| 41721 | 41721 | 1924-06-21 | 3 | f | Chinese football team on the way to visit New Zealand. | China | http://trove.nla.gov.au/newspaper/page/24100760 | 24100760 | |
| 41722 | 41722 | 1924-06-21 | 3 | f | Chinese community in Canada and the new restriction upon Chinese immigrant. | Canada | http://trove.nla.gov.au/newspaper/page/24100760 | 24100760 |
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]);