This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 39606 | 39606 | 1923-03-17 | 3 | a-b | Sun Yatsen talks on national unification of China. | China | http://trove.nla.gov.au/newspaper/page/24094334 | 24094334 | |
| 39607 | 39607 | 1923-03-17 | 3 | b-c | Unpredictable political situation in China. | America | http://trove.nla.gov.au/newspaper/page/24094334 | 24094334 | |
| 39608 | 39608 | 1923-03-17 | 3 | c | The Beijing cabinet has resigned. | America | http://trove.nla.gov.au/newspaper/page/24094334 | 24094334 | |
| 39609 | 39609 | 1923-03-17 | 3 | c | Soviet Russian government purchases weapons from Switzerland and Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24094334 | 24094334 | |
| 39610 | 39610 | 1923-03-17 | 3 | c | Chinese government notifies Japan to return the Lushun Port and to abrogate the Twenty-one Demands. | America | http://trove.nla.gov.au/newspaper/page/24094334 | 24094334 | |
| 39611 | 39611 | 1923-03-17 | 3 | d | British treasury reports to the parliament expenses for the World War I. | Britain | http://trove.nla.gov.au/newspaper/page/24094334 | 24094334 | |
| 39612 | 39612 | 1923-03-17 | 3 | c-f | Guangming Electronics Manufacturer Co Ltd raises funds by floating shares. Founders include Liang Chuang, Zhong Zhongshuo, Liang Zhongce, Hu Yaoting, Ye Tonggui, Ye Bingnan, Zeng Tingguang, Chen Lin, Zheng Fanchang, Lin Ziguang, Guo Chao, and many other Chinese businessmen in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094334 | 24094334 | |
| 39613 | 39613 | 1923-03-17 | 3 | d | A notice by Cai Chang of The Sun company in Hong Kong to shareholders. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094334 | 24094334 |
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]);