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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
56459 | 56459 | 1936-11-28 | 8 | c | Italy joins to 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 | |
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 | |
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 | |
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 | |
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 | |
56452 | 56452 | 1936-11-28 | 3 | c | Panic in Tokyo. | Japan | 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 | |
56450 | 56450 | 1936-11-28 | 3 | b | Austrian Prime Minister on his policy. | Other... | 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 | |
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 | |
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 |
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]);