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 | |
56442 | 56442 | 1936-11-21 | 8 | c | Airforce troops in Germany. | Germany | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
56443 | 56443 | 1936-11-21 | 8 | d | Japanese troops along the Yangtze River. | America | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
56437 | 56437 | 1936-11-21 | 3 | d | Police in Tokyo supervise the Chinese nationals. | Japan | http://trove.nla.gov.au/newspaper/page/24097067 | 24097067 | |
56440 | 56440 | 1936-11-21 | 8 | a | Soviet Russia gives in to Japanese demands | Britain | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
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 | |
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 | |
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 |
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]);