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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
56451 | 56451 | 1936-11-28 | 3 | b | Britain lends loans to China. | Britain | http://trove.nla.gov.au/newspaper/page/24097076 | 24097076 | |
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 | |
56459 | 56459 | 1936-11-28 | 8 | c | Italy joins to fight Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24097083 | 24097083 | |
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 | |
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 | |
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 | |
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 | |
56452 | 56452 | 1936-11-28 | 3 | c | Panic in Tokyo. | Japan | 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 | |
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 | |
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]);