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 |
|---|---|---|---|---|---|---|---|---|---|
| 55614 | 55614 | 1935-11-30 | 2 | b | Wang Jingwei is seriously injured in an assignation in Nanjing and the report. | China | http://trove.nla.gov.au/newspaper/page/24096660 | 24096660 | |
| 55615 | 55615 | 1935-11-30 | 2 | e | Japanese seduce Yan Xishan to organise another government in north China. | China | http://trove.nla.gov.au/newspaper/page/24096660 | 24096660 | |
| 55616 | 55616 | 1935-11-30 | 2 | e | Jiang Jieshi and his strategies to fight Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24096660 | 24096660 | |
| 55617 | 55617 | 1935-11-30 | 2 | f | Many villages in northeast of Siyang county, Jiangsu province, are flooded. | China | http://trove.nla.gov.au/newspaper/page/24096660 | 24096660 | |
| 55618 | 55618 | 1935-11-30 | 3 | a | Wang Jingwei, Song Ziwen and others meet in Nanjing on the relations with Japan. | China | http://trove.nla.gov.au/newspaper/page/24096659 | 24096659 | |
| 55619 | 55619 | 1935-11-30 | 3 | a | Nanjing government prepares to accept Japanese demands. | China | http://trove.nla.gov.au/newspaper/page/24096659 | 24096659 | |
| 55620 | 55620 | 1935-11-30 | 3 | c | League of Nations publishes report on the economic situations in China. | Other... | http://trove.nla.gov.au/newspaper/page/24096659 | 24096659 | |
| 55621 | 55621 | 1935-11-30 | 8 | c | Peasants in Hebei and Henan province organise their own rebellions against Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 | |
| 55622 | 55622 | 1935-11-30 | 3 | e | Jiang Jingguo, the eldest son of Jiang Jieshi, return to China from Russia. | China | http://trove.nla.gov.au/newspaper/page/24096659 | 24096659 | |
| 55623 | 55623 | 1935-11-30 | 5 | f | Advertisement of the Commonweal Loan to be issued by the Australian federal government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096661 | 24096661 | |
| 55624 | 55624 | 1935-11-30 | 5 | f | The Chinese Association in New Zealand acts as guarantee for Chinese students who are studying in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096661 | 24096661 | |
| 55625 | 55625 | 1935-11-30 | 6-7 | a-f | Guangdong news/ Japanese military commander Okamara visits Guangdong. South China improves its relationship with Japan. Bank of Guangdong is ready to reopen. Japanese seek to expand its market in south China. Guangdong businessmen are active after the visit of Okamara. Hong Kong and Shanghai Banking Corporation in Guangzhou. Businessmen need some national conscientiousness. Export of silver from China. Group wedding in Zhongshan county on the National Day. Villages are fighting for land in Panyu. Bandits in Xinhui. | China | http://trove.nla.gov.au/newspaper/page/24096664 | 24096664 | |
| 55626 | 55626 | 1935-11-30 | 8 | a | American government has approved the independence of the Philippines. | America | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 | |
| 55627 | 55627 | 1935-11-30 | 8 | a | Germany in heavy debt. | Germany | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 | |
| 55628 | 55628 | 1935-11-30 | 8 | b | Japanese demand autonomy of the five provinces in north China and the report. | China | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 | |
| 55629 | 55629 | 1935-11-30 | 8 | f | Australia news/ Chinese gardener is beaten in Sydney and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 |
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]);