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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 55769 | 55769 | 1936-02-01 | 3 | e | Eruption of the volcano in Hawaii. | America | 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 | |
| 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 | |
| 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 | |
| 55773 | 55773 | 1936-02-01 | 8 | a | Navigation across the Barents See of Russia. | Britain | 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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]);