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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
56456 | 56456 | 1936-11-28 | 8 | a | Japanese military plan in China. | Britain | http://trove.nla.gov.au/newspaper/page/24097083 | 24097083 | |
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 | |
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 | |
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 | |
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 | |
56452 | 56452 | 1936-11-28 | 3 | c | Panic in Tokyo. | Japan | 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 | |
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 | |
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 | |
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]);