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 |
|---|---|---|---|---|---|---|---|---|---|
| 55646 | 55646 | 1935-12-14 | 2 | b | Second part of editorial on Japanese invasion of China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096676 | 24096676 | |
| 55647 | 55647 | 1935-12-14 | 2 | c | China news/ Japanese troops in Shanghai. Japanese request Song Zheyuan to arrest Jiang Menglin, Hu Shi and other 130 persons. Japanese demands to the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24096676 | 24096676 | |
| 55648 | 55648 | 1935-12-14 | 2 | f | Taiwan governor helps Japanese invasion of south China. | China | http://trove.nla.gov.au/newspaper/page/24096676 | 24096676 | |
| 55649 | 55649 | 1935-12-14 | 2 | f | Feng Yuxiang in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24096676 | 24096676 | |
| 55650 | 55650 | 1935-12-14 | 3 | a | Japanese invasion of north China. | China | http://trove.nla.gov.au/newspaper/page/24096675 | 24096675 | |
| 55651 | 55651 | 1935-12-14 | 3 | c | American President Roosevelt on his foreign policy. | America | http://trove.nla.gov.au/newspaper/page/24096675 | 24096675 | |
| 55652 | 55652 | 1935-12-14 | 3 | e | A speech by Shi Zhaoji, Chinese ambassador to Washington. | America | http://trove.nla.gov.au/newspaper/page/24096675 | 24096675 | |
| 55653 | 55653 | 1935-12-14 | 5 | c | Advertisement of Simpson Lee's in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096677 | 24096677 | |
| 55654 | 55654 | 1935-12-14 | 5 | c | Chinese communities in New Zealand donate to the floods victims in China and names listed. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096677 | 24096677 | |
| 55655 | 55655 | 1935-12-14 | 6-7 | a-f | Guangdong news/ The cooperation between Guangdong and Nanjing. Li Zongren leaves Guangxi for Nanjing. Provincial government to issue new land certificate. Hong Kong businessmen reluctant to sell Japanese goods. More unemployed Chinese are returning from Canada. Many shops are closed down in Fuzhou, Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24096680 | 24096680 | |
| 55656 | 55656 | 1935-12-14 | 7 | a | Advertisement of the Chinese Joss House in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096679 | 24096679 | |
| 55657 | 55657 | 1935-12-14 | 8 | a | League of Nations to write to Italian government. | Other... | http://trove.nla.gov.au/newspaper/page/24096684 | 24096684 | |
| 55658 | 55658 | 1935-12-14 | 8 | a | The autonomous movement in north China. | China | http://trove.nla.gov.au/newspaper/page/24096684 | 24096684 | |
| 55659 | 55659 | 1935-12-14 | 8 | b | Atrocities of Japanese troops in north China. | China | http://trove.nla.gov.au/newspaper/page/24096684 | 24096684 | |
| 55660 | 55660 | 1935-12-14 | 8 | c | The new currency system in China and its effects. | China | http://trove.nla.gov.au/newspaper/page/24096684 | 24096684 | |
| 55661 | 55661 | 1935-12-14 | 8 | f | Australia news/ Aboriginal people may extinguish soon. Aged Australian women. Airmail service to connect Australia and China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096684 | 24096684 | |
| 55662 | 55662 | 1935-12-14 | 8 | e | Notice by the Chinese Chamber of Commerce in NSW on the ticket prices of liner service to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096684 | 24096684 |
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]);