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 |
---|---|---|---|---|---|---|---|---|---|
41826 | 41826 | 1924-07-19 | 2 | b-d | Chinese Ministry of Foreign Affairs in Beijing prepares for another negotiation with Russia. | China | http://trove.nla.gov.au/newspaper/page/24100793 | 24100793 | |
41828 | 41828 | 1924-07-19 | 2 | d-f | Big gathering in Beijing celebrates the friendship between China and Russia, and speakers include Wang Zhengting, Shen Ruilin and Russian foreign minister. | China | http://trove.nla.gov.au/newspaper/page/24100793 | 24100793 | |
41829 | 41829 | 1924-07-19 | 2 | f | Chinese President Cao Kun appoints Yang Sen governor of Sichuan province, and other appointments. | China | http://trove.nla.gov.au/newspaper/page/24100793 | 24100793 | |
41830 | 41830 | 1924-07-19 | 3 | a | Foreign missions in Beijing refuse to attend the tariff conference convened by the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24100792 | 24100792 | |
41831 | 41831 | 1924-07-19 | 3 | a-b | Wu Peifu in Luoyang, Henan province, talks about current situation in China. | China | http://trove.nla.gov.au/newspaper/page/24100792 | 24100792 | |
41832 | 41832 | 1924-07-19 | 3 | b-c | Further report on the possible reconciliation between Sun Yatsen and Chen Jiongming. | China | http://trove.nla.gov.au/newspaper/page/24100792 | 24100792 | |
41833 | 41833 | 1924-07-19 | 3 | c-d | First part of the constitution of the Guangdong Commercial Association for Self-defence. | China | http://trove.nla.gov.au/newspaper/page/24100792 | 24100792 | |
41834 | 41834 | 1924-07-19 | 3 | e | French ambassador in Beijing contacts Chinese foreign ministry for the treaty between Germany and China. | China | http://trove.nla.gov.au/newspaper/page/24100792 | 24100792 | |
41835 | 41835 | 1924-07-19 | 3 | f | Chinese and Russia resume diplomatic relations. | China | http://trove.nla.gov.au/newspaper/page/24100792 | 24100792 | |
41837 | 41837 | 1924-07-19 | 3 | f | The new treaty to be signed between China and Germany. | China | http://trove.nla.gov.au/newspaper/page/24100792 | 24100792 | |
41839 | 41839 | 1924-07-19 | 6 | b-c | A letter from Lu Rongting to Shen Hongying's officers and soldiers. | China | http://trove.nla.gov.au/newspaper/page/24100797 | 24100797 |
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]);