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 |
|---|---|---|---|---|---|---|---|---|---|
| 56447 | 56447 | 1936-11-28 | 2 | c | Yang Yongtai, governor of Hubei province, is assassinated. Manchurian troops on the way to Suiyuan. China and Japan sign agreement on aviation cooperation. Japanese new demands to the Nanjing government. Newspapers office in Nanjing on fire. Japanese troops in Fengtai have an exercise and the damages to crops. | China | http://trove.nla.gov.au/newspaper/page/24097077 | 24097077 | |
| 56448 | 56448 | 1936-11-28 | 3 | a | Sun Ke in Shanghai talks about situation in north China. | China | http://trove.nla.gov.au/newspaper/page/24097076 | 24097076 | |
| 56449 | 56449 | 1936-11-28 | 3 | a | Mass gathering in Taiyuan, Shanxi province, against Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097076 | 24097076 | |
| 56450 | 56450 | 1936-11-28 | 3 | b | Austrian Prime Minister on his policy. | Other... | http://trove.nla.gov.au/newspaper/page/24097076 | 24097076 | |
| 56451 | 56451 | 1936-11-28 | 3 | b | Britain lends loans to China. | Britain | http://trove.nla.gov.au/newspaper/page/24097076 | 24097076 | |
| 56452 | 56452 | 1936-11-28 | 3 | c | Panic in Tokyo. | Japan | http://trove.nla.gov.au/newspaper/page/24097076 | 24097076 | |
| 56453 | 56453 | 1936-11-28 | 3 | e | The future of business in China is pessimistic. | America | http://trove.nla.gov.au/newspaper/page/24097076 | 24097076 | |
| 56454 | 56454 | 1936-11-28 | 5 | c | First part of report on Guilin, new capital of Guangxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097078 | 24097078 | |
| 56455 | 56455 | 1936-11-28 | 6-7 | a-d | Guangdong news/ The central government troops are leaving Guangdong. Villagers are injured in a bomb blast in their farm. The Guangxi province after the peace negotiation. Japanese in Shantou. Gamblers in Shantou. Provincial government to enlist more soldiers. Japanese spy in Nanhai. Villagers shoot dead tiger in Luoding county. | China | http://trove.nla.gov.au/newspaper/page/24097081 | 24097081 | |
| 56456 | 56456 | 1936-11-28 | 8 | a | Japanese military plan in China. | Britain | http://trove.nla.gov.au/newspaper/page/24097083 | 24097083 | |
| 56457 | 56457 | 1936-11-28 | 8 | b | Germany and Japan sign agreement to jointly fight Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24097083 | 24097083 | |
| 56458 | 56458 | 1936-11-28 | 8 | b | Jiang Jieshi orders Fu Zuoyi to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097083 | 24097083 | |
| 56459 | 56459 | 1936-11-28 | 8 | c | Italy joins to fight Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24097083 | 24097083 | |
| 56460 | 56460 | 1936-11-28 | 8 | d | People in Shanghai raise funds to resist Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24097083 | 24097083 | |
| 56461 | 56461 | 1936-11-28 | 8 | e | Japanese military officer is kidnapped on the Beijing-Shenyang railway line. | China | http://trove.nla.gov.au/newspaper/page/24097083 | 24097083 | |
| 56462 | 56462 | 1936-11-28 | 8 | f | Australia news/ Chinese man in NSW wins lottery. Two female bandits rob factory in Melbourne. Chinese market gardener in NSW is beaten to death. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24097083 | 24097083 |
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]);