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 |
---|---|---|---|---|---|---|---|---|---|
53874 | 53874 | 1934-02-24 | 2 | a | Students demonstration in Shanghai and the arrests. | China | http://trove.nla.gov.au/newspaper/page/24091541 | 24091541 | |
53875 | 53875 | 1934-02-24 | 2 | b | The Nanjing government to issue more bonds in order to raise funds. | China | http://trove.nla.gov.au/newspaper/page/24091541 | 24091541 | |
53876 | 53876 | 1934-02-24 | 2 | d | The Nationalist government appoints Chen Yi to govern Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091541 | 24091541 | |
53877 | 53877 | 1934-02-24 | 2 | d | China's tariff revenue last year. | China | http://trove.nla.gov.au/newspaper/page/24091541 | 24091541 | |
53878 | 53878 | 1934-02-24 | 2 | e | Mongolian representatives meet Wang Jingwei in Nanjing for the issues of autonomous administration. | China | http://trove.nla.gov.au/newspaper/page/24091541 | 24091541 | |
53879 | 53879 | 1934-02-24 | 2 | e | Fujian troops retreat under the pressure of the Central Government army. | China | http://trove.nla.gov.au/newspaper/page/24091541 | 24091541 | |
53880 | 53880 | 1934-02-24 | 2 | f | Restoration of Puyi and the report. | China | http://trove.nla.gov.au/newspaper/page/24091541 | 24091541 | |
53881 | 53881 | 1934-02-24 | 3 | a | Fighting between Fujian and Jiang Jieshi's troops. | China | http://trove.nla.gov.au/newspaper/page/24091540 | 24091540 | |
53882 | 53882 | 1934-02-24 | 3 | b | Manchurian state draft its major policies following Japanese instruction. | China | http://trove.nla.gov.au/newspaper/page/24091540 | 24091540 | |
53886 | 53886 | 1934-02-24 | 3 | e | Japanese organise economic association in north China. | China | http://trove.nla.gov.au/newspaper/page/24091540 | 24091540 | |
53890 | 53890 | 1934-02-24 | 5 | d | Antiques discovered in Rizhao, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24091542 | 24091542 | |
53892 | 53892 | 1934-02-24 | 7-8 | a-f | Guangdong news/ Politicians in Guangdong urge Nanjing and Fujian to stop the fighting. Tan Qixiu and Chen Qixuan defect to the Nationalist army. Conference held in Guangxi for the peace in Guizhou province. Drugs in Taishan. | China | http://trove.nla.gov.au/newspaper/page/24091544 | 24091544 | |
53899 | 53899 | 1934-02-24 | 6 | e | Yan Xishan starts to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 |
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]);