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 |
|---|---|---|---|---|---|---|---|---|---|
| 45406 | 45406 | 1927-01-08 | 2 | c-d | Editorial by Tung Wah Times says that Russia should be closely watched. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101840 | 24101840 | |
| 45407 | 45407 | 1927-01-08 | 2 | d | The Chinese government and its attitude on the treaty with Belgium. | China | http://trove.nla.gov.au/newspaper/page/24101840 | 24101840 | |
| 45408 | 45408 | 1927-01-08 | 2 | e | The Chinese cabinet under Gu Weijun decides to take back Belgian concessions in China. | China | http://trove.nla.gov.au/newspaper/page/24101840 | 24101840 | |
| 45409 | 45409 | 1927-01-08 | 3 | c | A visitor to Shanghai on the step-down of Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24101839 | 24101839 | |
| 45410 | 45410 | 1927-01-08 | 3 | c | Military manoeuvre of Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24101839 | 24101839 | |
| 45411 | 45411 | 1927-01-08 | 3 | c | Chinese government drafts new policy to treat the Belgian nationals in China. | China | http://trove.nla.gov.au/newspaper/page/24101839 | 24101839 | |
| 45412 | 45412 | 1927-01-08 | 3 | d-f | First part of an open letter issued by commander-in-chief Jiang Jieshi to the nation wide. | China | http://trove.nla.gov.au/newspaper/page/24101839 | 24101839 | |
| 45413 | 45413 | 1927-01-08 | 3 | f | The future of trade between China and America. | America | http://trove.nla.gov.au/newspaper/page/24101839 | 24101839 | |
| 45414 | 45414 | 1927-01-08 | 3 | f | Liu Yuchun and Chen Jiamo to be on trial publicly. | China | http://trove.nla.gov.au/newspaper/page/24101839 | 24101839 | |
| 45415 | 45415 | 1927-01-08 | 5 | a-c | Miscellaneous report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101841 | 24101841 | |
| 45416 | 45416 | 1927-01-08 | 7 | a-b | Australia news/ Fire in Cairns, Queensland. Fire in Melbourne destroys dozens of shops on the New Year's day. Chinese chef is shot dead in Sydney by a white man. Chinese community in Darwin and their suffers. Chinese consulate-general in Melbourne has a new consul Liu Xi who is arriving in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101843 | 24101843 | |
| 45417 | 45417 | 1927-01-08 | 7 | d | Chinese immigrants are imprisoned in Cuba on arrival and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101843 | 24101843 | |
| 45418 | 45418 | 1927-01-08 | 8 | a-d | Guangdong news/ The reorganisation of the provincial government. The Nationalist authority takes over the Ningyang railway. The issue of government bonds in Shantou. Fighting in Fangcheng county between the Nationalist troops and local army. Liang Peiji is kidnapped. Magistrate of Dongguan county is charged and resigns. Naval captain Liang Yongji is found collaboration with bandits. Wu Tiecheng is still under house arrest. A survey on market price in Shilong town, of Gaoyao county. | China | http://trove.nla.gov.au/newspaper/page/24101846 | 24101846 |
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]);