This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46409 | 46409 | 1927-11-12 | 2 | b | Editorial by Tung Wah Times on the bandits in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098592 | 24098592 | |
46410 | 46410 | 1927-11-12 | 2 | b | Mei Lanfang in Beijing is robbed and Zhang Hanju is murdered. | China | http://trove.nla.gov.au/newspaper/page/24098592 | 24098592 | |
46415 | 46415 | 1927-11-12 | 3 | b | Buddhism and arts in Wutaishan Mountain, Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24098591 | 24098591 | |
46423 | 46423 | 1927-11-12 | 5 | b | Japan wants to delay its talks with China over the Manchurian issues. | Japan | http://trove.nla.gov.au/newspaper/page/24098593 | 24098593 | |
46424 | 46424 | 1927-11-12 | 5 | b | Wang Jingwei returns to Guangzhou. Women guests crushed to death in a Shanghai restaurant on a false fire alarm. Security for the celebration of October Revolution at the Soviet Russian consulate in Shanghai. News on the war between Yan Xishan (Shanxi) and Zhang Zuolin (Fengxi). | China | http://trove.nla.gov.au/newspaper/page/24098593 | 24098593 | |
46426 | 46426 | 1927-11-12 | 7 | b | Floods in New England, America. | America | http://trove.nla.gov.au/newspaper/page/24098595 | 24098595 | |
46427 | 46427 | 1927-11-12 | 7 | b | Guangdong news/ Business in Foshan. Brief biography of Zou Minchu, acting treasurer of the provincial government. Sericulture in Zhongshan and Shunde county. Local security corps organised in Xinhui county. Land price in Zhongshan county. Vietnamese authority abolishes new regulations on Chinese medicine. | China | http://trove.nla.gov.au/newspaper/page/24098595 | 24098595 |
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]);