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 |
---|---|---|---|---|---|---|---|---|---|
55769 | 55769 | 1936-02-01 | 3 | e | Eruption of the volcano in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24096727 | 24096727 | |
55777 | 55777 | 1936-02-01 | 8 | c | Japan and Australia to sign new trade agreement. | Australia | http://trove.nla.gov.au/newspaper/page/24096734 | 24096734 | |
55766 | 55766 | 1936-02-01 | 3 | c | Hitler and his ambition. | Britain | http://trove.nla.gov.au/newspaper/page/24096727 | 24096727 | |
55767 | 55767 | 1936-02-01 | 3 | e | Britain refuses to sign air defence agreement with Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24096727 | 24096727 | |
55773 | 55773 | 1936-02-01 | 8 | a | Navigation across the Barents See of Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24096734 | 24096734 | |
55775 | 55775 | 1936-02-01 | 8 | b | Japan and Germany sign a military agreement. | Britain | http://trove.nla.gov.au/newspaper/page/24096734 | 24096734 | |
55776 | 55776 | 1936-02-01 | 8 | b | The death of King George V and the new king Edward. | Britain | http://trove.nla.gov.au/newspaper/page/24096734 | 24096734 | |
55761 | 55761 | 1936-02-01 | 2 | d | Japanese businessmen in Shanghai and the new currency sytem initiated by the Chinese government. | China | http://trove.nla.gov.au/newspaper/page/24096728 | 24096728 | |
55762 | 55762 | 1936-02-01 | 2 | e | Japanese in north China force Song Zheyuan to withdraw troops from Tongzhou, between Beijing and Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24096728 | 24096728 | |
55763 | 55763 | 1936-02-01 | 2 | e | Newly-appointed Deputy Transportation Minister of the Nanjing government Tang Youren is assassinated in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096728 | 24096728 | |
55764 | 55764 | 1936-02-01 | 3 | a | Japanese ambition in north China. Coming conflict between Japan and Russia. | China | http://trove.nla.gov.au/newspaper/page/24096727 | 24096727 | |
55765 | 55765 | 1936-02-01 | 3 | c | Outer Mongolian government dispatches more troops to the border with Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096727 | 24096727 | |
55768 | 55768 | 1936-02-01 | 3 | e | More Japanese troops are gathering in north China. | China | http://trove.nla.gov.au/newspaper/page/24096727 | 24096727 | |
55770 | 55770 | 1936-02-01 | 5 | a | The "Republic of Mongolia" and a report. | China | http://trove.nla.gov.au/newspaper/page/24096730 | 24096730 | |
55772 | 55772 | 1936-02-01 | 6-7 | a-d | Guangdong news/ Li Zongren's troops to fight the communists under Ye Ting and He Long. A declaration issued by the Guangzhou Students' Association. Guangzhou municipal government to clear the city streets. Government authority to monopolise the silk industry. Bandits in Dongguan. An investigation on the tragedy during drama perfornance in Zengcheng. | China | http://trove.nla.gov.au/newspaper/page/24096732 | 24096732 | |
55778 | 55778 | 1936-02-01 | 8 | d | The Chinese Communist troops in Guiyang, Guizhou province, under Xiao Ke. | China | http://trove.nla.gov.au/newspaper/page/24096734 | 24096734 | |
55774 | 55774 | 1936-02-01 | 8 | a | Sales of Japanese flour going up dramatically. | Japan | http://trove.nla.gov.au/newspaper/page/24096734 | 24096734 | |
55760 | 55760 | 1936-02-01 | 2 | b | Editorial by Tung Wah Times examines the domestic and foreign policies of the Chinese government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096728 | 24096728 | |
55771 | 55771 | 1936-02-01 | 5 | b | A women island in the Nanyang area. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096730 | 24096730 | |
55779 | 55779 | 1936-02-01 | 8 | e | Australia news/ Chinese gardens robbed in the Sydney suburb. Chinese gardener is drowned in NSW. Tax to be exempted for flour sales. Some savings in the Savings Bank of New South Wales can not find owners. Chinese gardener is injured in an accident. Opium seized from passenger liner Taiping. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096734 | 24096734 |
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]);