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 |
---|---|---|---|---|---|---|---|---|---|
55837 | 55837 | 1936-02-29 | 8 | A | Japan seeks to sign military agreement with Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 | |
55829 | 55829 | 1936-02-29 | 3 | a | American people criticise the new currency system in China. | America | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
55836 | 55836 | 1936-02-29 | 6-7 | a-d | Guangdong news/ Fireworks in Macao kill six people. Japanese counsel initiates another negotiation with the Shantou government. Guangzhou welcomes Hu Hanmin. Zou Yunhe invents new materials for paper manufacturing. Russian arm smugglers detained in Guangzhou. Central government sends fleet to welcome Hu Hanmin. The international business last year and a detailed report. Zengcheng county legislature member is detained for opium smoking. | China | http://trove.nla.gov.au/newspaper/page/24096764 | 24096764 | |
55826 | 55826 | 1936-02-29 | 2 | b | Editorial on the volunteer army organised by the Guangzhou students. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096760 | 24096760 | |
55830 | 55830 | 1936-02-29 | 3 | b | Revenue of the Chinese customs last year. | China | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
55831 | 55831 | 1936-02-29 | 3 | b | America purchase silver from China. | America | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
55832 | 55832 | 1936-02-29 | 3 | b | British navy have an exercise in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
55838 | 55838 | 1936-02-29 | 8 | b | Germany is preparing for war. | Britain | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 | |
55835 | 55835 | 1936-02-29 | 5 | c | First part of a speech by Hu Hanmin. | China | http://trove.nla.gov.au/newspaper/page/24096761 | 24096761 | |
55839 | 55839 | 1936-02-29 | 8 | c | Spanish government takes over all land. | Other... | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 | |
55827 | 55827 | 1936-02-29 | 2 | d | Song Zheyuan retreats back under the pressure of Japanese army. | China | http://trove.nla.gov.au/newspaper/page/24096760 | 24096760 | |
55828 | 55828 | 1936-02-29 | 2 | d | The central government in Nanjing has finalised its strategies to deal with crisis in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096760 | 24096760 | |
55833 | 55833 | 1936-02-29 | 3 | d | German businessmen sign trade agreement with Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
55840 | 55840 | 1936-02-29 | 8 | d | Cold weather in North America. | America | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 | |
55841 | 55841 | 1936-02-29 | 8 | d | Small pox in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 | |
55842 | 55842 | 1936-02-29 | 8 | d | Election in Japan and the winner. | Japan | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 | |
55834 | 55834 | 1936-02-29 | 3 | e | British government has a national defence conference. | Britain | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
55843 | 55843 | 1936-02-29 | 8 | e | Australia news/ The Lingnan University in Guangzhou sends representative to collect donations among the Australian Chinese communities. Overseas Chinese Committee in Shanghai writes to the Chinese Chamber of Commerce in Sydney. Australia exports wheat to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 | |
55844 | 55844 | 1936-02-29 | 8 | f | Chese chef is sought by a Western restaurant in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 | |
55845 | 55845 | 1936-02-29 | 8 | f | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 |
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]);