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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
55831 | 55831 | 1936-02-29 | 3 | b | America purchase silver from China. | America | 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 | |
55834 | 55834 | 1936-02-29 | 3 | e | British government has a national defence conference. | Britain | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
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 | |
55838 | 55838 | 1936-02-29 | 8 | b | Germany is preparing for war. | Britain | 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 | |
55830 | 55830 | 1936-02-29 | 3 | b | Revenue of the Chinese customs last year. | China | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
55833 | 55833 | 1936-02-29 | 3 | d | German businessmen sign trade agreement with Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
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 | |
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 | |
55842 | 55842 | 1936-02-29 | 8 | d | Election in Japan and the winner. | Japan | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 | |
55839 | 55839 | 1936-02-29 | 8 | c | Spanish government takes over all land. | Other... | 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 | |
55832 | 55832 | 1936-02-29 | 3 | b | British navy have an exercise in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
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 | |
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]);