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 |
---|---|---|---|---|---|---|---|---|---|
54028 | 54028 | 1934-04-07 | 2 | a | Huang Hechun's troops are disarmed. | China | http://trove.nla.gov.au/newspaper/page/24095964 | 24095964 | |
54032 | 54032 | 1934-04-07 | 3 | a | Attitude of the Nanjing government towards the puppet Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
54043 | 54043 | 1934-04-07 | 6 | a | Japanese to build a naval port in Thailand. | Britain | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54042 | 54042 | 1934-04-07 | 7-8 | a-f | Guangdong news/ Jiang Dingwen arrives Guangzhou and his talks. Five airports to be built in Guangdong. Jiang Jieshi proposes to Chen Jitang to set up new offices. Li Yangjing on the work of appeasement in the east of Guangdong. Huang Hechun is retired now. Soldiers of the 19th Route Army are passing through Guangdong. A man in Guangzhou fights ghost. Li Zongren enhances military power of Guangxi. New office to be organised for business tax collection. A man returned from New York to set up an insurance company for virgin girls. An aged woman of 120 in Lechang county. Silk industry in Guangdong may see prosperity. All people of a village in Zhongshan county are fleeing because of drugs involvement. Bandits in Zengcheng. | China | http://trove.nla.gov.au/newspaper/page/24095967 | 24095967 | |
54029 | 54029 | 1934-04-07 | 2 | b | Puyi becomes the emperor of Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24095964 | 24095964 | |
54033 | 54033 | 1934-04-07 | 3 | b | Britain to expand its naval forces. | Britain | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
54044 | 54044 | 1934-04-07 | 6 | b | Zheng Xiaoxu is going to Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54045 | 54045 | 1934-04-07 | 6 | b | Religious conflicts in India. | Other... | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54034 | 54034 | 1934-04-07 | 3 | c | Response of the Chinese troops in Manchuria to the puppet Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
54035 | 54035 | 1934-04-07 | 3 | c | Police in Thailand kill Chinese immigrants. | China | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
54046 | 54046 | 1934-04-07 | 6 | c | Japanese response to the sale of Australian flour in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54047 | 54047 | 1934-04-07 | 6 | c | A New Zealander is detained by Japanese in Tokyo. | Britain | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54030 | 54030 | 1934-04-07 | 2 | d | Fu Zhankui to meet Sun Dianying. Nanjing government continues to put pressure upon Sun Dianying. | China | http://trove.nla.gov.au/newspaper/page/24095964 | 24095964 | |
54036 | 54036 | 1934-04-07 | 3 | d | Sun Dianying in Ningxia and his confrontation with the central authority. | China | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
54048 | 54048 | 1934-04-07 | 6 | d | Japanese purchase army provisions from America. | America | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54049 | 54049 | 1934-04-07 | 6 | d | Japan and Britain to start trade talks. | Japan | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54050 | 54050 | 1934-04-07 | 6 | d | Tibet people invites a Living Buddha to return. | Other... | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54031 | 54031 | 1934-04-07 | 2 | e | China news/ Key figures from north China come to meet Zhang Xueliang in Wuhan. Yin Rugeng on the Gubei Fortification. Proposed changes to the constitution. Traitors in Tianjin support puppet Emperor Puyi. | China | http://trove.nla.gov.au/newspaper/page/24095964 | 24095964 | |
54037 | 54037 | 1934-04-07 | 3 | e | France disagrees with Britain on the international disarmament. | America | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
54038 | 54038 | 1934-04-07 | 3 | e | Soviet Russia criticises the puppet Manchurian state. | Russia | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
54039 | 54039 | 1934-04-07 | 3 | e | Germany will not recognise the Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
54051 | 54051 | 1934-04-07 | 6 | e | Japan regards China as its protectorate. | Russia | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54052 | 54052 | 1934-04-07 | 6 | e | Australia news/ Chinese businessmen come to purchase wool in Australia. Japanese businessmen organise exhibition of Japanese goods in Sydney. Storm in Western Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54040 | 54040 | 1934-04-07 | 3 | f | Japanese troops in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
54041 | 54041 | 1934-04-07 | 5 | f | A notice issued by the Sydney Chinese Fund-raising Committee for the war of resistance to Japanese invasion. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095965 | 24095965 |
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]);