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 |
---|---|---|---|---|---|---|---|---|---|
38913 | 38913 | 1922-06-24 | 2-3 | f-a | Sun Yatsen talks to Western journalist in Guangzhou, part II. | China | http://trove.nla.gov.au/newspaper/page/24094018 | 24094018 | |
38914 | 38914 | 1922-06-24 | 3 | b | Why Zhang Zuolin is defeated and an analysis. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38915 | 38915 | 1922-06-24 | 3 | b-c | More report on the war between Wu Peifu and Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38916 | 38916 | 1922-06-24 | 3 | d | The war in Jiangxi province (Li Liejun and his troops have entered Nanxiong). | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38917 | 38917 | 1922-06-24 | 3 | d-e | Sun Chuanfang suggests to resume the old parliament with Li Yuanhong as the President. This suggestion is also supported by Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38918 | 38918 | 1922-06-24 | 3 | e | Yan Huiqing becomes acting premier while retains his foreign affairs minister. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38922 | 38922 | 1922-06-24 | 3 | f | Sun Yatsen has fled Guangzhou, and another report. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38923 | 38923 | 1922-06-24 | 3 | f | Chinese President Li Yuanhong pardons Zhang Zuolin. | China | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38928 | 38928 | 1922-06-24 | 6 | c-d | Sun Yatsen has returned to Guangdong secretly. | China | http://trove.nla.gov.au/newspaper/page/24094022 | 24094022 | |
38929 | 38929 | 1922-06-24 | 6 | d | Gu Yingfeng leaves Guangdong for Shanghai, via Hong Kong. | China | http://trove.nla.gov.au/newspaper/page/24094022 | 24094022 | |
38943 | 38943 | 1922-06-24 | 8 | a | Third part of an investigation report on government bonds in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094024 | 24094024 |
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]);