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 |
|---|---|---|---|---|---|---|---|---|---|
| 54830 | 54830 | 1935-02-02 | 2 | b | Editorial on the elimination of remains of communist forces in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096311 | 24096311 | |
| 54831 | 54831 | 1935-02-02 | 2 | c | China news/ A military officer in Jiangxi talks about suppression of the communist troops. Import of perfume and cosmetics last year. Sun Ke in Shanghai talks about unity. Mail services connect Beijing and Shenyang now. Liu Guitang and his troops in north China. Jiang Jieshi on the way to Hangzhou. Demand of silver dollars in Shanghai. Yang Jie reports his investigation on army provisions in various countries. | China | http://trove.nla.gov.au/newspaper/page/24096311 | 24096311 | |
| 54832 | 54832 | 1935-02-02 | 3 | a | Japanese sailor shoots and injures Chinese customs officer and the investigation. | China | http://trove.nla.gov.au/newspaper/page/24096310 | 24096310 | |
| 54833 | 54833 | 1935-02-02 | 3 | a | The communist troops in Guangxi. | China | http://trove.nla.gov.au/newspaper/page/24096310 | 24096310 | |
| 54834 | 54834 | 1935-02-02 | 3 | b | Chinese communities in Britain learn traditional Chinese culture and their new school. | Britain | http://trove.nla.gov.au/newspaper/page/24096310 | 24096310 | |
| 54835 | 54835 | 1935-02-02 | 3 | d | British navy seeks to consolidate their defence in the Pacific region. | Britain | http://trove.nla.gov.au/newspaper/page/24096310 | 24096310 | |
| 54836 | 54836 | 1935-02-02 | 3 | d | China reduces its contribution to the League of Nations. | Other... | http://trove.nla.gov.au/newspaper/page/24096310 | 24096310 | |
| 54837 | 54837 | 1935-02-02 | 3 | e | Traitors are very active in Tangshan, Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24096310 | 24096310 | |
| 54838 | 54838 | 1935-02-02 | 5 | a | Sixth part of a study on the development of northwest China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096312 | 24096312 | |
| 54839 | 54839 | 1935-02-02 | 5 | d | Chinese Society in Melbourne to have drama performance. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096312 | 24096312 | |
| 54840 | 54840 | 1935-02-02 | 5 | e | Chinese communities in Sydney donate to the welcome of Prince of Britain and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096312 | 24096312 | |
| 54841 | 54841 | 1935-02-02 | 5 | f | Advertisement for the Sydney Chinese School and its admission. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096312 | 24096312 | |
| 54842 | 54842 | 1935-02-02 | 7-8 | a-f | Guangdong news/ Suppression of the communist troops in south China and the involvement of Guangdong troops. Primary school teachers request for the salary payment. Steel production in Guangdong. Tang Shaoyi resigns. Internal conflicts of the commercial circle in Shantou. Bandits in Taishan. Businessmen in Gaoyao request to ban drama performance. Army reserves in Gaoming. Restaurants in Haikou, of Hainan island. High school in Dongguan prepares for exhibition. Bandits in Boluo. | China | http://trove.nla.gov.au/newspaper/page/24096314 | 24096314 | |
| 54843 | 54843 | 1935-02-02 | 6 | a | Rumours on the political agreement between China and Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096315 | 24096315 | |
| 54844 | 54844 | 1935-02-02 | 6 | a | Imports of Hong Kong last year. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096315 | 24096315 | |
| 54845 | 54845 | 1935-02-02 | 6 | b | Heavy snow traps train in Vancouver, Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24096315 | 24096315 | |
| 54846 | 54846 | 1935-02-02 | 6 | c | Resistance to Japanese invasion in north China. | China | http://trove.nla.gov.au/newspaper/page/24096315 | 24096315 | |
| 54847 | 54847 | 1935-02-02 | 6 | e | Australia news/ Chinese swimmer Guo Zhenheng wins two matches in Melbourne. Candidates for the trade commissioner to the Far East. Opium found under railway tracks. Japanese confidence on the New Year. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096315 | 24096315 |
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]);