This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
56382 | 56382 | 1936-11-07 | 2 | b | General Cai Tingkai arrives Wuzhou of Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24097052 | 24097052 | |
56383 | 56383 | 1936-11-07 | 2 | b | Japanese in north China force Song Zheyuan to defect from the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24097052 | 24097052 | |
56384 | 56384 | 1936-11-07 | 2 | c | China news/ Debts of the Nanjing government. He Yingqin may replace Chen Cheng very soon. Statistics of China's import of luxurious goods. Shanghai municipal authority arrests anti-Japanese activists. Nanjing prepares to celebrate the birthday of Jiang Jieshi. Ma Xiangbo is sick. Zhang Xueliang denies assassination. Chen Weipin resigns. | China | http://trove.nla.gov.au/newspaper/page/24097052 | 24097052 | |
56385 | 56385 | 1936-11-07 | 3 | a | Envoy of Japanese government to meet Jiang Jieshi in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24097051 | 24097051 | |
56386 | 56386 | 1936-11-07 | 3 | a | Demonstrations in Shanghai against Japanese invaders and the response of Japanese authority. | China | http://trove.nla.gov.au/newspaper/page/24097051 | 24097051 | |
56390 | 56390 | 1936-11-07 | 3 | d | Japanese provide weapons to the bandits in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24097051 | 24097051 | |
56395 | 56395 | 1936-11-07 | 6-7 | a-d | Guangdong news/ Jiang Jieshi suddenly leaves Guangzhou for Nanjing. Xiao Focheng leaves Hong Kong for Thailand. The Nanjing authority leaves six divisions to station in Guangdong. Japanese in Shantou and their drug smuggling. Guangdong banks to issue more notes. Rich Chinese businessman in San Francisco Zhou Song is returning to China. Nanjing authority to control the economy and army of Guangdong province. Japanese delegation to inspect Hong Kong. Bandits in Taishan county. Villagers in Gaoming county sue the magistrate. | China | http://trove.nla.gov.au/newspaper/page/24097056 | 24097056 | |
56399 | 56399 | 1936-11-07 | 8 | e | Yan Xishan in Shanxi province deports Japanese smugglers. | China | http://trove.nla.gov.au/newspaper/page/24097058 | 24097058 | |
56400 | 56400 | 1936-11-07 | 8 | e | Civilians donate warplanes in Nanjing to the Central government troops. | China | http://trove.nla.gov.au/newspaper/page/24097058 | 24097058 | |
56402 | 56402 | 1936-11-07 | 8 | f | Celebration in Nanjing of the birthday of Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24097058 | 24097058 |
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]);