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 | |
| 54029 | 54029 | 1934-04-07 | 2 | b | Puyi becomes the emperor of Manchurian state. | China | http://trove.nla.gov.au/newspaper/page/24095964 | 24095964 | |
| 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 | |
| 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 | |
| 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 | |
| 54033 | 54033 | 1934-04-07 | 3 | b | Britain to expand its naval forces. | Britain | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 |
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]);