This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 45419 | 45419 | 1927-01-15 | 2 | c-d | Editorial by Tung Wah Times on the unification of China peacefully or by force. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101848 | 24101848 | |
| 45420 | 45420 | 1927-01-15 | 2 | d | Number of languages in the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101848 | 24101848 | |
| 45421 | 45421 | 1927-01-15 | 2 | e | Yang Yuting on the current situation and the strategies of Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24101848 | 24101848 | |
| 45422 | 45422 | 1927-01-15 | 3 | c | Wu Peifu understands Yang Sen. | China | http://trove.nla.gov.au/newspaper/page/24101847 | 24101847 | |
| 45423 | 45423 | 1927-01-15 | 3 | c-d | Second part of the open letter issued by commander-in-chief Jiang Jieshi to the nation wide. | China | http://trove.nla.gov.au/newspaper/page/24101847 | 24101847 | |
| 45424 | 45424 | 1927-01-15 | 3 | d-e | Prominent Guomindang figures arrives Jiangxi province (Song Ziwen, Song Qingling, Yan Mengyu, Sun Ke, and Borodin). | China | http://trove.nla.gov.au/newspaper/page/24101847 | 24101847 | |
| 45425 | 45425 | 1927-01-15 | 3 | f | Report on the conference in Zhengzhou attended by Qi Xieyuan, Tian Weiqin and others. | China | http://trove.nla.gov.au/newspaper/page/24101847 | 24101847 | |
| 45426 | 45426 | 1927-01-15 | 3 | f | Trade between Finland and China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101847 | 24101847 | |
| 45427 | 45427 | 1927-01-15 | 5 | a | British and Chinese scientists start a joint exploration in the Northwest China. | Britain | http://trove.nla.gov.au/newspaper/page/24101849 | 24101849 | |
| 45428 | 45428 | 1927-01-15 | 5 | a | Chinese sailor is punished for arms smuggling. | Britain | http://trove.nla.gov.au/newspaper/page/24101849 | 24101849 | |
| 45429 | 45429 | 1927-01-15 | 5 | a-c | Miscellaneous report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101849 | 24101849 | |
| 45430 | 45430 | 1927-01-15 | 7 | a-b | A meeting notice issued by the Chinese Chamber of Commerce in Sydney. Japanese and Australian swimmers have a match in Sydney. Car racing in New South Wales and the accident. A wedding in the hospital in Sydney. A Chinese arts gallery in Sydney organised by Huang Guangzhao, Guo Jianying, Zhan Fu, Pan Yonghan and Huang Guoqiang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101851 | 24101851 | |
| 45431 | 45431 | 1927-01-15 | 8 | a-d | Guangdong news/ Director of the public security bureau in Guangzhou takes over the tap water company. Production resumed at the munitions factory in Guangdong. Jiang Jieshi rebuffs proposal to move the capital of Nationalist government. Civil corps in Luoding. Manslaughter in Gaoyao county. Proposal to close down all private schools in Guangzhou. Bandits in Zengcheng county and their robbery. Clash over the tap water company in Guangzhou. Ban on workers' fighting in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24101854 | 24101854 |
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]);