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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
53252 | 53252 | 1933-09-02 | 6 | c | Floods of the Yellow River. | China | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53244 | 53244 | 1933-09-02 | 3 | e | France to expand its overseas colonies. | France | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53248 | 53248 | 1933-09-02 | 5 | e | Government officials are not civil servants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091351 | 24091351 | |
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 | |
53235 | 53235 | 1933-09-02 | 2 | e | Guangdong troops in Fujian suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24091350 | 24091350 | |
53254 | 53254 | 1933-09-02 | 6 | d | Japanese navy and their exercise. | Japan | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
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 | |
53242 | 53242 | 1933-09-02 | 3 | e | Jewish people in Germany and their life. | Germany | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
53237 | 53237 | 1933-09-02 | 3 | a | The crisis in Chaha'er, north China. | China | 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 | |
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 | |
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 |
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]);