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 |
---|---|---|---|---|---|---|---|---|---|
53255 | 53255 | 1933-09-02 | 6 | e | Australia news/ Chinese gardener dies in Sydney mysteriously. An armed robbery of gambling den in Sydney. Earthquake in Victoria. The death of Huang Si, Chinese businessman in Sydney and accountant of the Chinese Baptism Church. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53254 | 53254 | 1933-09-02 | 6 | d | Japanese navy and their exercise. | Japan | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53253 | 53253 | 1933-09-02 | 6 | d | Rebellions of the Muslims in Xinjiang area, northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53252 | 53252 | 1933-09-02 | 6 | c | Floods of the Yellow River. | China | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53251 | 53251 | 1933-09-02 | 6 | a | Oppositions to the international peace conference in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53250 | 53250 | 1933-09-02 | 6 | a | A conference of the Pacific countries to be held in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53249 | 53249 | 1933-09-02 | 7-8 | a-f | Guangdong news/ Different opinions on the organisation of the southwest authority. Opposition to Jiang Jieshi in the southwest of China. Huang Guangrui inspects Humen fortifications. Preparation for infrastructure in Guangzhou. Municipal bank retrieves one cent coins. Shareholders' meeting of The Sun Company in Shanghai. Government and businessmen to jointly open a ship line to the Nanyang area. Python found in Qingyuan county. | China | http://trove.nla.gov.au/newspaper/page/24091353 | 24091353 | |
53248 | 53248 | 1933-09-02 | 5 | e | Government officials are not civil servants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091351 | 24091351 | |
53247 | 53247 | 1933-09-02 | 5 | b | Writings by Liang Chaowen, a native of Taishan county, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091351 | 24091351 | |
53246 | 53246 | 1933-09-02 | 5 | a | Five major coal and iron mines in north China. | China | http://trove.nla.gov.au/newspaper/page/24091351 | 24091351 | |
53245 | 53245 | 1933-09-02 | 3 | e | Japanese to build oil wells in Rehe province, north China. | China | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53244 | 53244 | 1933-09-02 | 3 | e | France to expand its overseas colonies. | France | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53243 | 53243 | 1933-09-02 | 3 | e | Ma Zhanshan tours Mogan Mountain in Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53242 | 53242 | 1933-09-02 | 3 | e | Jewish people in Germany and their life. | Germany | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53241 | 53241 | 1933-09-02 | 3 | d | Public opinions in Japan attack Britain and Russia. | Japan | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53240 | 53240 | 1933-09-02 | 3 | d | The puppet Manchurian state government finalises new tax rates. | China | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53239 | 53239 | 1933-09-02 | 3 | d | British newspaper on the international technological cooperation. | Britain | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53238 | 53238 | 1933-09-02 | 3 | c | Chinese communities in Vietnam help Feng Yuxiang's troops. | China | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53237 | 53237 | 1933-09-02 | 3 | a | The crisis in Chaha'er, north China. | China | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53236 | 53236 | 1933-09-02 | 2 | e | Relief Committee set up in the war zones of north China. | China | http://trove.nla.gov.au/newspaper/page/24091350 | 24091350 | |
53235 | 53235 | 1933-09-02 | 2 | e | Guangdong troops in Fujian suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24091350 | 24091350 | |
53234 | 53234 | 1933-09-02 | 2 | d | Wang Jingwei on the way to meet Jiang Jieshi in Nanchang. | China | http://trove.nla.gov.au/newspaper/page/24091350 | 24091350 | |
53233 | 53233 | 1933-09-02 | 2 | c | Liu Wenhui's troops in the south of Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24091350 | 24091350 | |
53232 | 53232 | 1933-09-02 | 2 | b | Members of the Central Executive Committee in Shanghai condemn Wang Jingwei. | China | http://trove.nla.gov.au/newspaper/page/24091350 | 24091350 | |
53231 | 53231 | 1933-09-02 | 2 | a | Second part of an editorial on Japanese conspiracy of their proposed Asian alliance. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091350 | 24091350 |
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]);