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 |
---|---|---|---|---|---|---|---|---|---|
55355 | 55355 | 1935-08-17 | 3 | d | America and Russia sign a trade agreement. | America | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
55351 | 55351 | 1935-08-17 | 3 | a | Japanese prime minister and his power. | Japan | 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 | |
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 | |
55354 | 55354 | 1935-08-17 | 3 | c | Political turmoil in Austria. | Other... | http://trove.nla.gov.au/newspaper/page/24096536 | 24096536 | |
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 | |
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 | |
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 |
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]);