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 |
|---|---|---|---|---|---|---|---|---|---|
| 56430 | 56430 | 1936-11-21 | 2 | b | A declaration jointly issued by 77 school teachers in north China to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097068 | 24097068 | |
| 56431 | 56431 | 1936-11-21 | 2 | c | General Cai Tingkai in Wuzhou, of Guangxi province, and his talks. | China | http://trove.nla.gov.au/newspaper/page/24097068 | 24097068 | |
| 56432 | 56432 | 1936-11-21 | 2 | d | Envoy of Japanese government to meet Jiang Jieshi in Nanjing. Determination of the civil people in north China to resist Japanese invasion. Zhang Xueliang talks to British journalists on the resistance to Japanese invasion. Japanese have recruited many traitors in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24097068 | 24097068 | |
| 56433 | 56433 | 1936-11-21 | 3 | a | Soviet Russian soldiers shoot border guards of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24097067 | 24097067 | |
| 56434 | 56434 | 1936-11-21 | 3 | a | Britain and America are closely watching situations in the Far East. | Britain | http://trove.nla.gov.au/newspaper/page/24097067 | 24097067 | |
| 56435 | 56435 | 1936-11-21 | 3 | b | The Times in London on Japanese invasion of China. | Britain | http://trove.nla.gov.au/newspaper/page/24097067 | 24097067 | |
| 56436 | 56436 | 1936-11-21 | 3 | d | China and Britain reach agreement over commercial loans. | Britain | http://trove.nla.gov.au/newspaper/page/24097067 | 24097067 | |
| 56437 | 56437 | 1936-11-21 | 3 | d | Police in Tokyo supervise the Chinese nationals. | Japan | http://trove.nla.gov.au/newspaper/page/24097067 | 24097067 | |
| 56438 | 56438 | 1936-11-21 | 6-7 | a-d | Guangdong news/ Celebrations in Guangzhou for the birthday of Jiang Jieshi. The three-year plan drafted by the Guangdong provincial government. Poor harvest in the Dongjiang area. Chen Cheng on the way to Guangzhou again. Wu Xianzi arrives Hong Kong safely. Troops of the central government are leaving Guangdong for the north. Clan feud and fighting in Zengcheng and Panyu county. Woman injured in a fire in Xinhui. | China | http://trove.nla.gov.au/newspaper/page/24097072 | 24097072 | |
| 56439 | 56439 | 1936-11-21 | 8 | a | Japanese military commanders seek to influence upon the politics. | Japan | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
| 56440 | 56440 | 1936-11-21 | 8 | a | Soviet Russia gives in to Japanese demands | Britain | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
| 56441 | 56441 | 1936-11-21 | 8 | b | British parliament on the military conflict between China and Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
| 56442 | 56442 | 1936-11-21 | 8 | c | Airforce troops in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
| 56443 | 56443 | 1936-11-21 | 8 | d | Japanese troops along the Yangtze River. | America | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
| 56444 | 56444 | 1936-11-21 | 8 | e | The bridge project in San Francisco is completed. | America | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
| 56445 | 56445 | 1936-11-21 | 8 | f | Japanese suspect Jiang Jieshi's motive to suppress the Chinese Communist forces | China | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
| 56446 | 56446 | 1936-11-21 | 8 | g | Australia news/ An old Chinese man dies in Sydney nursing home mysteriously. Farmers in NSW suffers from the continuing drought. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 |
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]);