This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
Link | rowid | date | page | column | title | description | source ▼ | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53888 | 53888 | 1934-02-24 | 5 | a | Prose by Liang Chaojie on the birthday of his mother. | America | http://trove.nla.gov.au/newspaper/page/24091542 | 24091542 | |
53885 | 53885 | 1934-02-24 | 3 | e | Britain and France dispute over trade issues. | Britain | http://trove.nla.gov.au/newspaper/page/24091540 | 24091540 | |
53887 | 53887 | 1934-02-24 | 3 | f | Germany repays debt to Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24091540 | 24091540 | |
53893 | 53893 | 1934-02-24 | 6 | a | Cannons used during the World War I. | Britain | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53894 | 53894 | 1934-02-24 | 6 | c | Earthquake in India. | Britain | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53895 | 53895 | 1934-02-24 | 6 | c | Chaos in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53897 | 53897 | 1934-02-24 | 6 | d | Britain to expand its navy. | Britain | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
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 | |
53883 | 53883 | 1934-02-24 | 3 | c | American President Roosevelt and his Japan policy. | Japan | http://trove.nla.gov.au/newspaper/page/24091540 | 24091540 | |
53884 | 53884 | 1934-02-24 | 3 | d | Japanese navy and the growth. | Japan | http://trove.nla.gov.au/newspaper/page/24091540 | 24091540 | |
53896 | 53896 | 1934-02-24 | 6 | c | Indian parliament passes the budget report. | Other... | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53898 | 53898 | 1934-02-24 | 6 | d | Chaos in Austria. | Other... | http://trove.nla.gov.au/newspaper/page/24091545 | 24091545 | |
53889 | 53889 | 1934-02-24 | 5 | c | Ten warnings for love. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091542 | 24091542 | |
53891 | 53891 | 1934-02-24 | 5 | f | Notice by Liu Guangfu (William Liu) on the book, White China, and before his departure to visit China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091542 | 24091542 | |
53900 | 53900 | 1934-02-24 | 6 | e | Australia news/ Federal government appoints trade commissioner to the Far East. Two Chinese men on trial in Sydney for defraud. Russian tourist talks about Manchuria on his arrival in Australia. Chinese man arrested for being involved in theft. Storm in New South Wales and the damages. | Tung Wah | 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]);