This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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]);