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 |
|---|---|---|---|---|---|---|---|---|---|
| 51631 | 51631 | 1932-06-25 | 2 | a | Editorial by Tung Wah Times on the resumption of diplomatic relations between China and Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090848 | 24090848 | |
| 51632 | 51632 | 1932-06-25 | 2 | c | Report prepared by delegation of the League of Nations on Japanese invasion of China. | China | http://trove.nla.gov.au/newspaper/page/24090848 | 24090848 | |
| 51633 | 51633 | 1932-06-25 | 2 | d | He Zhuguo seeks comprise with Japanese. | China | http://trove.nla.gov.au/newspaper/page/24090848 | 24090848 | |
| 51634 | 51634 | 1932-06-25 | 2 | e | Resistance in Manchuria to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090848 | 24090848 | |
| 51635 | 51635 | 1932-06-25 | 2 | f | Jiang Jieshi to stay in Wuhan in order to eradicate the communist forces. | China | http://trove.nla.gov.au/newspaper/page/24090848 | 24090848 | |
| 51636 | 51636 | 1932-06-25 | 2 | f | The 19th Route Army on the way to Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24090848 | 24090848 | |
| 51637 | 51637 | 1932-06-25 | 3 | a | The aftermath of the war in Shanghai between Chinese and Japanese troops. | China | http://trove.nla.gov.au/newspaper/page/24090847 | 24090847 | |
| 51638 | 51638 | 1932-06-25 | 5 | a | Compensation of Germany after the World War I and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090850 | 24090850 | |
| 51639 | 51639 | 1932-06-25 | 5 | c | Chinese communities in Sydney and Melbourne donate to the war of resistance in China and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090850 | 24090850 | |
| 51640 | 51640 | 1932-06-25 | 6-7 | a-f | Guangdong news/ Reorganisation of naval and airforce troops in Guangdong and the obstacles. The 19th Route Army on the way to fight communist forces in Fujian province. Guangdong people help fight the communist forces. Provincial authority on the current situation. American planes arrive Guangdong. Ferry service may stop in local Guangdong. A robbery in Xinhui. Nanhai county authority reform traditional marriage custom. Building of fortifications in Guangzhou. Unemployed women in Nanhai, Shunde and Panyu. Clan fighting in Taishan. | China | http://trove.nla.gov.au/newspaper/page/24090852 | 24090852 | |
| 51641 | 51641 | 1932-06-25 | 8 | a | Casualties of Japanese troops in Shanghai. | Japan | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
| 51642 | 51642 | 1932-06-25 | 8 | a | Delegation of the League of Nations in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
| 51643 | 51643 | 1932-06-25 | 8 | a | Japan recognises the Manchurian puppet state. | Japan | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
| 51644 | 51644 | 1932-06-25 | 8 | b | British warships on the way to Chile. | Britain | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
| 51645 | 51645 | 1932-06-25 | 8 | c | Another coup in Chile. | Other... | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
| 51646 | 51646 | 1932-06-25 | 8 | c | Spanish government confiscates properties owned by former emperor. | Britain | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
| 51647 | 51647 | 1932-06-25 | 8 | c | Japanese instruct the Manchurian state to collect tariff. | China | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
| 51648 | 51648 | 1932-06-25 | 8 | c | Australia news/ Statistics of international trade of the NSW. An old Chinese disappear in Queensland. New South Wales has a new cabinet. Letter from the Bank of China to the Chinese Progressive Association in Sydney. Australian federal government on the defence. Drunken driver is penalised in Sydney. Snowing in Sydney suburbs. New premier of NSW state on administration. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 |
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]);