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 |
|---|---|---|---|---|---|---|---|---|---|
| 54105 | 54105 | 1934-05-05 | 2 | a | Editorial on the resistance in China to Japanese invasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096002 | 24096002 | |
| 54106 | 54106 | 1934-05-05 | 2 | b | China news/ Traitors in Qingdao and their conspiracy. Japan opposes to the building of new airports in Fujian province. Fourth part of the draft constitution of the Republic of China. | China | http://trove.nla.gov.au/newspaper/page/24096002 | 24096002 | |
| 54107 | 54107 | 1934-05-05 | 3 | a | Japanese control the economy in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096001 | 24096001 | |
| 54108 | 54108 | 1934-05-05 | 3 | a | Japanese military strategies of invasion of China. | China | http://trove.nla.gov.au/newspaper/page/24096001 | 24096001 | |
| 54109 | 54109 | 1934-05-05 | 3 | b | The coming meeting of the international disarmament conference. | Britain | http://trove.nla.gov.au/newspaper/page/24096001 | 24096001 | |
| 54110 | 54110 | 1934-05-05 | 3 | c | China and Turkey sign friendship treaty. | China | http://trove.nla.gov.au/newspaper/page/24096001 | 24096001 | |
| 54111 | 54111 | 1934-05-05 | 3 | d | Japanese troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24096001 | 24096001 | |
| 54112 | 54112 | 1934-05-05 | 3 | e | Sun Dianying's troops have been reorganised. | China | http://trove.nla.gov.au/newspaper/page/24096001 | 24096001 | |
| 54113 | 54113 | 1934-05-05 | 3 | e | Britain, America and France send envoy to investigate in China. | China | http://trove.nla.gov.au/newspaper/page/24096001 | 24096001 | |
| 54114 | 54114 | 1934-05-05 | 5 | a | Statue of Huang Keqiang is set up in the Huanghe Pagoda, Wuhan. | China | http://trove.nla.gov.au/newspaper/page/24096004 | 24096004 | |
| 54115 | 54115 | 1934-05-05 | 5 | b | Literary writings by Guo Moruo. | China | http://trove.nla.gov.au/newspaper/page/24096004 | 24096004 | |
| 54116 | 54116 | 1934-05-05 | 5 | c | Li Liwong on the Spring life. | China | http://trove.nla.gov.au/newspaper/page/24096004 | 24096004 | |
| 54117 | 54117 | 1934-05-05 | 5 | e | Birthday celebration for Duan Qirui. | China | http://trove.nla.gov.au/newspaper/page/24096004 | 24096004 | |
| 54118 | 54118 | 1934-05-05 | 7-8 | a-f | Guangdong news/ The suppress of communist troops in south China. Jiang Jieshi agrees to appropriate more funds to Guangdong army. Debate on the draft constitution of the Republic of China. Provincial authority has secured more loans from gambling and tobacco businessmen. Guangxi trains the civil corps. Mao Weishou is going overseas for a military investigation. Civil aviation service in the southwest. Guangdong shares the refunds of Boxer Indemnity. A case of murder in Dongguan. Rich businessman kidnapped in Zhongshan. Temples built in Meilu for Confucius, Mencius and Yue Fei. | China | http://trove.nla.gov.au/newspaper/page/24096005 | 24096005 | |
| 54119 | 54119 | 1934-05-05 | 6 | a | Political chaos in Havana, Cuba. | Other... | http://trove.nla.gov.au/newspaper/page/24096006 | 24096006 | |
| 54120 | 54120 | 1934-05-05 | 6 | a | Britain's ultimate to Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096006 | 24096006 | |
| 54121 | 54121 | 1934-05-05 | 6 | b | Foreign newspapers comments on Japan's declaration towards China. | Britain | http://trove.nla.gov.au/newspaper/page/24096006 | 24096006 | |
| 54122 | 54122 | 1934-05-05 | 6 | c | Japanese seek to control the whole Asia. | Other... | http://trove.nla.gov.au/newspaper/page/24096006 | 24096006 | |
| 54123 | 54123 | 1934-05-05 | 6 | c | Agreement reached among Baltic countries. | Other... | http://trove.nla.gov.au/newspaper/page/24096006 | 24096006 | |
| 54124 | 54124 | 1934-05-05 | 6 | c | Soviet Russia comments on Japan's warnings to China. | Russia | http://trove.nla.gov.au/newspaper/page/24096006 | 24096006 | |
| 54125 | 54125 | 1934-05-05 | 6 | d | Japan has finalised its plan of invasion of Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24096006 | 24096006 | |
| 54126 | 54126 | 1934-05-05 | 6 | d | Japan and the airforce troops of Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24096006 | 24096006 | |
| 54127 | 54127 | 1934-05-05 | 6 | e | Australia news/ Warehouse on fire in Darwin. Celebrations on the ANZAC Day. A robbery in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096006 | 24096006 |
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]);