This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47445 | 47445 | 1928-09-22 | 8 | a | Remains of the troops in Zhili and Shandong province under Zhang Zongchang. | China | http://trove.nla.gov.au/newspaper/page/24098960 | 24098960 | |
47446 | 47446 | 1928-09-22 | 8 | a | Businessmen in Shanghai oppose to dog racing. | China | http://trove.nla.gov.au/newspaper/page/24098960 | 24098960 | |
47447 | 47447 | 1928-09-22 | 8 | a | British, French and Japanese ambassadors in China send ultimate to the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24098960 | 24098960 | |
47448 | 47448 | 1928-09-22 | 8 | a | The Chinese government signs the peace treaty. | China | http://trove.nla.gov.au/newspaper/page/24098960 | 24098960 | |
47449 | 47449 | 1928-09-22 | 8 | a | Storm and damages in Puerto Rico. | Other... | http://trove.nla.gov.au/newspaper/page/24098960 | 24098960 | |
47450 | 47450 | 1928-09-22 | 8 | a | Soviet Union may change policies formulated by Lenin. | Britain | http://trove.nla.gov.au/newspaper/page/24098960 | 24098960 | |
47451 | 47451 | 1928-09-22 | 8 | b | German businessmen propose for aviation service from Berlin to Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24098960 | 24098960 | |
47452 | 47452 | 1928-09-22 | 8 | b | Australia news/ A farewell party organised by the Chinese Chamber of Commerce in Sydney for departing Chinese consul-general Wei Zijing and speakers also include Wu Zhaoquan, Liang Lanxin, Zhu Hechou, Zheng Fanchang, Ye Bingnan, Liu Guangfu, Guo Jianying, and Wu Qinfen. A Sydney girl gives birth to a baby fathered by her maternal uncle. A man in Sydney murders his wife and then commits suicide. Farewell party for Wei Zijing at the passenger liner Changte. Further report on the dockers' strike in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098960 | 24098960 |
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]);