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 |
---|---|---|---|---|---|---|---|---|---|
55358 | 55358 | 1935-08-17 | 8 | d | Australia news/ The Chinese Chamber of Commerce in New South Wales donates to relief work of flooding areas in China. Visitor talks about air defence in Japan on his return to Sydney. Chinese suspect on trial in Sydney for murder. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096542 | 24096542 | |
55357 | 55357 | 1935-08-17 | 6-7 | a-f | Guangdong news/ Li Zongren to return to Guangxi. Guangdong provincial authority repeats its ban on gambling in rural areas. Relief work in the rural areas of Guangdong. Provincial government approves to build trolley bus routes. Guangzhou educational authority to reform textbooks of primary schools. Panic of industrial and commercial fields in Shanghai. A case of murder in Zhongshan county. Smuggling in Shantou. Security officer in Qingyuan county visits prostitute. Villagers in Panyu kill tiger. | China | http://trove.nla.gov.au/newspaper/page/24096541 | 24096541 | |
55356 | 55356 | 1935-08-17 | 5 | f | Donations to the Melbourne Chinese School and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096539 | 24096539 | |
55355 | 55355 | 1935-08-17 | 3 | d | America and Russia sign a trade agreement. | America | http://trove.nla.gov.au/newspaper/page/24096536 | 24096536 | |
55354 | 55354 | 1935-08-17 | 3 | c | Political turmoil in Austria. | Other... | http://trove.nla.gov.au/newspaper/page/24096536 | 24096536 | |
55353 | 55353 | 1935-08-17 | 3 | c | Manchurian state seeks to set up consulate office in Russia but is declined. | Japan | http://trove.nla.gov.au/newspaper/page/24096536 | 24096536 | |
55352 | 55352 | 1935-08-17 | 3 | c | American parliament approves to manufacture more warplanes. | America | http://trove.nla.gov.au/newspaper/page/24096536 | 24096536 | |
55351 | 55351 | 1935-08-17 | 3 | a | Japanese prime minister and his power. | Japan | http://trove.nla.gov.au/newspaper/page/24096536 | 24096536 | |
55350 | 55350 | 1935-08-17 | 3 | a | Guo Taiqi speaks in London on the diplomatic relations between China and Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24096536 | 24096536 | |
55349 | 55349 | 1935-08-17 | 3 | a | Business tycoons in Zhejiang province and their relations with the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24096536 | 24096536 | |
55348 | 55348 | 1935-08-17 | 2 | f | Japanese troops in Tianjin have an exercise. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 | |
55347 | 55347 | 1935-08-17 | 2 | f | The New Life Weekly is closed down in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 | |
55346 | 55346 | 1935-08-17 | 2 | e | Woman Wang Zhenkun becomes local administrator in Guangxi. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 | |
55345 | 55345 | 1935-08-17 | 2 | d | The floods of Yellow River and victims in southwest Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 | |
55344 | 55344 | 1935-08-17 | 2 | b | Floods of the Yangtze River and the danger of Wuhan. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 | |
55343 | 55343 | 1935-08-17 | 2 | b | Japanese have totally control the judicial system of China, claims by Wu Kaisheng. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 |
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]);