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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
55833 | 55833 | 1936-02-29 | 3 | d | German businessmen sign trade agreement with Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096759 | 24096759 | |
55834 | 55834 | 1936-02-29 | 3 | e | British government has a national defence conference. | Britain | 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 | |
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 | |
55839 | 55839 | 1936-02-29 | 8 | c | Spanish government takes over all land. | 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 | |
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 | |
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]);