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 |
---|---|---|---|---|---|---|---|---|---|
54278 | 54278 | 1934-07-07 | 2 | c | Feng Yuxiang arrives Penglai, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24096076 | 24096076 | |
54279 | 54279 | 1934-07-07 | 2 | d | The economic alliance between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24096076 | 24096076 | |
54280 | 54280 | 1934-07-07 | 2 | f | Soviet Russia double-track the railways in the Far East. | China | http://trove.nla.gov.au/newspaper/page/24096076 | 24096076 | |
54281 | 54281 | 1934-07-07 | 2 | f | Resistance of Chinese army to Japanese invasion in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096076 | 24096076 | |
54282 | 54282 | 1934-07-07 | 3 | a | Japan and Russia are preparing for the coming war. | China | http://trove.nla.gov.au/newspaper/page/24096075 | 24096075 | |
54283 | 54283 | 1934-07-07 | 3 | a | Zhu Qiqing surveys the land for cultivation in Suiyuan province. | China | http://trove.nla.gov.au/newspaper/page/24096075 | 24096075 | |
54284 | 54284 | 1934-07-07 | 3 | b | Resistance of Chinese troops to Japanese invasion in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096075 | 24096075 | |
54286 | 54286 | 1934-07-07 | 3 | d | Jiang Jieshi orders to suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24096075 | 24096075 | |
54289 | 54289 | 1934-07-07 | 3 | e | Floods in south Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24096075 | 24096075 | |
54290 | 54290 | 1934-07-07 | 3 | f | Building of the Yellow River dams starts. | China | http://trove.nla.gov.au/newspaper/page/24096075 | 24096075 | |
54291 | 54291 | 1934-07-07 | 5 | a | A girl in Guangzhou tests and selects husband. | China | http://trove.nla.gov.au/newspaper/page/24096077 | 24096077 | |
54294 | 54294 | 1934-07-07 | 7-8 | a-f | Guangdong news/ Jiang Jieshi sows discords between Guangdong and Guangxi. Financial authority investigates a case of defraud. Munitions factory in Guangdong. The First Group Army in Guangdong. Japanese are preparing to invade south China. Japanese seek to lease out the Hainan island. Wang Guangtian and his plan to recover Guangdong economy. Rubber prices going up and more Chinese are returning to Singapore. A case of rape in Dongguan. Air defence gathering in Zhongshan county. Beggars in Huiyang county. Civilians in Xinhui county condemn gambling. | China | http://trove.nla.gov.au/newspaper/page/24096079 | 24096079 |
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]);