This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50672 | 50672 | 1931-09-05 | 2 | d | Guangdong comprises with Jiang Jieshi once again. Nanjing government seeks to extradite Chen Youren from Japan. Japanese government demands Chen Youren to leave. Jiang Jieshi prepares for war with Guangdong. Xu Shiying demands funds for relief work. Wang Zhengting on China's foreign policy. Recent talks between China and Russia. Song Ziwen refuses to recognise the bonds issued by Guangdong government. Guangdong and Guangxi pay the tariff income to Shanghai. Annual meeting of the Engineering Association of China. | China | http://trove.nla.gov.au/newspaper/page/24090511 | 24090511 | |
50675 | 50675 | 1931-09-05 | 3 | d | Sichuan provincial government to issue a special bonds in order to deal with the aftermath of war. | China | http://trove.nla.gov.au/newspaper/page/24090510 | 24090510 |
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]);