This data as json, CSV (advanced)
Suggested facets: page, column, 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 | |
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 | |
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 | |
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 |
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]);