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 |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 55348 | 55348 | 1935-08-17 | 2 | f | Japanese troops in Tianjin have an exercise. | China | http://trove.nla.gov.au/newspaper/page/24096537 | 24096537 | |
| 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 | |
| 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 | |
| 55351 | 55351 | 1935-08-17 | 3 | a | Japanese prime minister and his power. | 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 | |
| 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 | |
| 55355 | 55355 | 1935-08-17 | 3 | d | America and Russia sign a trade agreement. | America | 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 | |
| 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 | |
| 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 |
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]);