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 |
---|---|---|---|---|---|---|---|---|---|
54079 | 54079 | 1934-04-21 | 3 | d | A city in Japan disappears after a fire. | Japan | http://trove.nla.gov.au/newspaper/page/24095979 | 24095979 | |
54089 | 54089 | 1934-04-21 | 6 | d | Australia news/ Wool export increases. Japanese goods on the world market. Chinese communities in Sydney farewell Guo Jianying on his return to China. Two Chinese men in Sydney on trial for fighting. A Chinese man commits suicide in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
54076 | 54076 | 1934-04-21 | 2 | b | China news/ Japanese troops continue to harass the north China. Second part of the draft constitution of Republic of China. Jiang Jieshi to convene a national conference on administrative reform. Zheng Xiaoxu on the way to Japan to sign treaty. Seventieth birthday of Duan Qirui. | China | http://trove.nla.gov.au/newspaper/page/24095980 | 24095980 | |
54075 | 54075 | 1934-04-21 | 2 | a | Editorial on the status of Puyi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095980 | 24095980 | |
54085 | 54085 | 1934-04-21 | 6 | a | Germany reorganises its military forces. | Britain | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
54082 | 54082 | 1934-04-21 | 7-8 | a-f | Guangdong news/ The Huangpu Navy School is managed by the Headquarters. Li Zongren leaves Nanning for Guangzhou. Cai Tingkai is going overseas. The Southwest authority requests the Nanjing government to investigate on the Chinese immigrants murdered in Thailand. Guangdong manufactures five aeroplanes. Candidate finalised for the provincial governor. New requirements for payment of land and security taxes in Guangzhou. Exhibition in Guangzhou of the air defence equipment. Tang Shaoyi requests to cancel the export tax of China products. Efforts to save business in Hong Kong. Registration of sand land. Fighting in Boluo between bandits and government troops. | China | http://trove.nla.gov.au/newspaper/page/24095989 | 24095989 | |
54081 | 54081 | 1934-04-21 | 5 | f | How much Japanese have secured from Manchuria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095987 | 24095987 | |
54078 | 54078 | 1934-04-21 | 3 | a | Japan and America start a secret talk. | Britain | http://trove.nla.gov.au/newspaper/page/24095979 | 24095979 | |
54084 | 54084 | 1934-04-21 | 6 | a | Japanese defence minister resigns. | Japan | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
54087 | 54087 | 1934-04-21 | 6 | c | Japanese pressure on China. | Japan | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
54083 | 54083 | 1934-04-21 | 6 | a | Russian plane saves sailors. | Russia | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
54077 | 54077 | 1934-04-21 | 3 | a | Sun Dianying vows to fight to the end. | China | http://trove.nla.gov.au/newspaper/page/24095979 | 24095979 | |
54088 | 54088 | 1934-04-21 | 6 | d | Thailand government denies any cooperation with Japan for river project. | Other... | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
54086 | 54086 | 1934-04-21 | 6 | c | Tibet to reduce its army numbers. | Other... | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
54080 | 54080 | 1934-04-21 | 5 | d | Women's bathroom in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095987 | 24095987 |
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]);