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 |
---|---|---|---|---|---|---|---|---|---|
55845 | 55845 | 1936-02-29 | 8 | f | Liner timetable. | 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 | |
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 | |
55842 | 55842 | 1936-02-29 | 8 | d | Election in Japan and the winner. | Japan | 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 | |
55840 | 55840 | 1936-02-29 | 8 | d | Cold weather in North America. | America | 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 | |
55838 | 55838 | 1936-02-29 | 8 | b | Germany is preparing for war. | Britain | http://trove.nla.gov.au/newspaper/page/24096766 | 24096766 | |
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 | |
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 | |
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 | |
55834 | 55834 | 1936-02-29 | 3 | e | British government has a national defence conference. | Britain | 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 | |
55832 | 55832 | 1936-02-29 | 3 | b | British navy have an exercise in Singapore. | Singapore | 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 | |
55830 | 55830 | 1936-02-29 | 3 | b | Revenue of the Chinese customs last year. | China | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
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 | |
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 | |
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 | |
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 |
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]);