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 |
---|---|---|---|---|---|---|---|---|---|
51645 | 51645 | 1932-06-25 | 8 | c | Another coup in Chile. | Other... | 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 | |
51644 | 51644 | 1932-06-25 | 8 | b | British warships on the way to Chile. | Britain | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
51641 | 51641 | 1932-06-25 | 8 | a | Casualties of Japanese troops in Shanghai. | Japan | http://trove.nla.gov.au/newspaper/page/24090854 | 24090854 | |
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 | |
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 | |
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 | |
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 | |
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 | |
51633 | 51633 | 1932-06-25 | 2 | d | He Zhuguo seeks comprise with Japanese. | China | http://trove.nla.gov.au/newspaper/page/24090848 | 24090848 | |
51643 | 51643 | 1932-06-25 | 8 | a | Japan recognises the Manchurian puppet state. | Japan | 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 | |
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 | |
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 | |
51634 | 51634 | 1932-06-25 | 2 | e | Resistance in Manchuria to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090848 | 24090848 | |
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 | |
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 |
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]);