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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
53235 | 53235 | 1933-09-02 | 2 | e | Guangdong troops in Fujian suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24091350 | 24091350 | |
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 | |
53237 | 53237 | 1933-09-02 | 3 | a | The crisis in Chaha'er, north China. | China | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
53252 | 53252 | 1933-09-02 | 6 | c | Floods of the Yellow River. | China | 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 |
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]);