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 |
---|---|---|---|---|---|---|---|---|---|
53967 | 53967 | 1934-03-17 | 3 | e | American report on the secret treaty between Germany and Japan. | America | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
53981 | 53981 | 1934-03-17 | 6 | e | Australia news/ Dr Kuang Fuzhuo arrives Sydney from New Zealand. Import of tea and wine increases. Court hearing on the defraud of Chinese businessmen in Sydney. Chinese man in Sydney is arrested for laziness. Trial on the theft of Chinese garden in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53966 | 53966 | 1934-03-17 | 3 | e | Britain may send trade commissioner to Manchuria. | Britain | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
53973 | 53973 | 1934-03-17 | 6 | a | British navy to have exercise. | Britain | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53961 | 53961 | 1934-03-17 | 2 | f | Central government in Nanjing continues to dispatch troops to Fujian. | China | http://trove.nla.gov.au/newspaper/page/24091565 | 24091565 | |
53968 | 53968 | 1934-03-17 | 3 | e | China's trade deficit last year. | China | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
53970 | 53970 | 1934-03-17 | 5 | b | Chinese Ministry of Education prints part of the Four Classics. | China | http://trove.nla.gov.au/newspaper/page/24091566 | 24091566 | |
53977 | 53977 | 1934-03-17 | 6 | d | Chinese man in Singapore shoots dead police officer. | Singapore | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53955 | 53955 | 1934-03-17 | 2 | a | Comments on the system of leadership. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091565 | 24091565 | |
53969 | 53969 | 1934-03-17 | 5 | a | Destiny of the 19th Route Army. | China | http://trove.nla.gov.au/newspaper/page/24091566 | 24091566 | |
53978 | 53978 | 1934-03-17 | 6 | d | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53979 | 53979 | 1934-03-17 | 6 | d | Farmers in Korea and Manchuria attack Japanese soldiers. | Japan | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53972 | 53972 | 1934-03-17 | 7-8 | a-f | Guangdong news/ Military cooperation of Guangdong and Guangxi. Cai Tingkai leaves the 19th Route Army and Jiang Jieshi's reorganisation effort. Chen Jitang to strengthen border defence between Guangdong and Fujian. Whereabouts of Chen Mingshu, Li Jishen, Jiang Guanglai and Cai Tingkai. Cai Tingkai arrives Hong Kong. Business in Dayu area. More temporary shops opened in Guangzhou before the Chinese New Year. Attitude towards the China products in Guangzhou. Local administrator is murdered in Panyu. Police in Taishan raid drug dens. | China | http://trove.nla.gov.au/newspaper/page/24091568 | 24091568 | |
53975 | 53975 | 1934-03-17 | 6 | c | Japanese business in Indochina. | Japan | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53980 | 53980 | 1934-03-17 | 6 | d | Japanese seek to restore the emperor system in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53976 | 53976 | 1934-03-17 | 6 | d | Jiang Jieshi denies dictatorship charges. | China | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53960 | 53960 | 1934-03-17 | 2 | e | Jiang Jieshi leaves Hangzhou for Nanchang. | China | http://trove.nla.gov.au/newspaper/page/24091565 | 24091565 | |
53958 | 53958 | 1934-03-17 | 2 | d | Jiang Jieshi to eradicate all opposition forces in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24091565 | 24091565 | |
53956 | 53956 | 1934-03-17 | 2 | c | Kong Xiangxi borrows loans in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091565 | 24091565 | |
53974 | 53974 | 1934-03-17 | 6 | b | Muslim government in Xinjiang collapses. | China | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
53963 | 53963 | 1934-03-17 | 3 | b | Number of Chinese troops in Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
53971 | 53971 | 1934-03-17 | 5 | e | On divorce. On prostitute. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091566 | 24091566 | |
53965 | 53965 | 1934-03-17 | 3 | d | Russian government increases salary payment to the Red Army in the Far East. | Russia | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
53964 | 53964 | 1934-03-17 | 3 | b | Sun Dianying and his troops in Ningxia. | China | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
53959 | 53959 | 1934-03-17 | 2 | e | The 19th Route Army after being reorganised. | China | http://trove.nla.gov.au/newspaper/page/24091565 | 24091565 | |
53962 | 53962 | 1934-03-17 | 3 | a | Victory of Kong Xianrong and his resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
53957 | 53957 | 1934-03-17 | 2 | c | Zhang Xueliang has a new appointment. | China | http://trove.nla.gov.au/newspaper/page/24091565 | 24091565 |
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]);