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 |
---|---|---|---|---|---|---|---|---|---|
56134 | 56134 | 1936-08-08 | 2 | b | China has lost Inner Mongolia following the Outer, comments by Tung Wah Times editorial. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096946 | 24096946 | |
56135 | 56135 | 1936-08-08 | 2 | c | China news/ Song Zheyuan on the alliance of the five provinces in north China and their peace efforts. Coal mine found in Sichuan province. Plague of locusts in Hebei province. Song Zheyuan retreats his troops from Fengtai, south suburb of Beijing. Yan Xishan requests Jiang Jieshi to stop internal fighting and to resist foreign invasion. Opening of the Second Plenary in Nanjing and the dispute between Nanjing and Guangzhou authorities. Tang Shaoyi may be elected the president of China. Japanese tanks enter Beijing and their exercise. | China | http://trove.nla.gov.au/newspaper/page/24096946 | 24096946 | |
56136 | 56136 | 1936-08-08 | 3 | a | Japanese cabinet to meet and debate new policies. | Japan | http://trove.nla.gov.au/newspaper/page/24096945 | 24096945 | |
56137 | 56137 | 1936-08-08 | 3 | a | Negotiation is halted between Britain and Soviet Union over the naval cooperation. | Britain | http://trove.nla.gov.au/newspaper/page/24096945 | 24096945 | |
56138 | 56138 | 1936-08-08 | 3 | b | Japanese cabinet finalise new policy. Japanese are preparing for invasion of the Philippines. | Japan | http://trove.nla.gov.au/newspaper/page/24096945 | 24096945 | |
56139 | 56139 | 1936-08-08 | 3 | d | French government takes over all military industries. | France | http://trove.nla.gov.au/newspaper/page/24096945 | 24096945 | |
56140 | 56140 | 1936-08-08 | 3 | e | Delegation of the Manchurian government arrives Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24096945 | 24096945 | |
56141 | 56141 | 1936-08-08 | 5 | b | Story of Zhang Qian, the first Chinese adventurer. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096947 | 24096947 | |
56142 | 56142 | 1936-08-08 | 6-7 | a-d | Guangdong news/ Military officers in Guangdong and Guangxi uphold their policies. Payment increased for airforce commanders. Yu Hanmou on the way to meet Jiang Jieshi in Nanjing. National defence in south China and the coming Japanese invasion. Farming cattle robbed in Dongguan. Taishan county authority seize silver from shops. | China | http://trove.nla.gov.au/newspaper/page/24096950 | 24096950 | |
56143 | 56143 | 1936-08-08 | 8 | a | Britain to build big warships and America follows. | Britain | http://trove.nla.gov.au/newspaper/page/24096952 | 24096952 | |
56144 | 56144 | 1936-08-08 | 8 | c | The communist movement in Europe. | Britain | http://trove.nla.gov.au/newspaper/page/24096952 | 24096952 | |
56145 | 56145 | 1936-08-08 | 8 | d | Suspect on trial in London for attempted assassination of King of Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24096952 | 24096952 | |
56146 | 56146 | 1936-08-08 | 8 | e | The unavoidable internal war in China. | China | http://trove.nla.gov.au/newspaper/page/24096952 | 24096952 | |
56147 | 56147 | 1936-08-08 | 8 | e | Military conflict between Jiang Jieshi and the Guangxi army. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096952 | 24096952 | |
56148 | 56148 | 1936-08-08 | 8 | f | Australia news/ Expert claims that the land in north NSW suitable for tea tree growing. Britain is still leading the world economy. Export of Australian wines and the statistics. Members of Rotary Club from Australia on the way to visit China and Japan. Counterfeit bank notes found in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096952 | 24096952 | |
56149 | 56149 | 1936-08-08 | 8 | g | Advertisement of the Neon Signs (Asia) Ltd in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096952 | 24096952 |
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]);