This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50669 | 50669 | 1931-09-05 | 2 | b | First part of editorial on the negotiation between China and Japan over the atrocity of Japanese police in Jilin province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090511 | 24090511 | |
50670 | 50670 | 1931-09-05 | 2 | c | Circular telegram issued by Jiang Jieshi on the current situation. | China | http://trove.nla.gov.au/newspaper/page/24090511 | 24090511 | |
50671 | 50671 | 1931-09-05 | 2 | c | General inspector of the Chinese customs Mei Lehe urges Guangdong to pay their debts. | China | http://trove.nla.gov.au/newspaper/page/24090511 | 24090511 | |
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 |
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]);