This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44989 | 44989 | 1926-07-24 | 7 | a-d | Australia news/ Recommended by Tang Longxiang, Ling Ying becomes chief editor of the World News (gong bao), of the zhi gong tang in Sydney, his backgrounds and the welcome ceremony at the zhi gong tang headquarters in Sydney. Three sisters are all thieves in Manly, Sydney. A family of four murdered in Sydney and the police investigation. An old woman found in naked in Sydney. Yellow Cabs company makes profit in Sydney and Melbourne. State government of New South Wales to reduce market prices. Investigation in Melbourne on the murder of Chinese Lin Guang. A tea party notice by the Chinese Presbyterian church in Sydney. Advertisement for Marshall Shoe Co. Ltd, Sydney. Storm in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101643 | 24101643 | |
44990 | 44990 | 1926-07-24 | 8 | a-d | Guangdong news/ Zhao Hengti asks Jiang Jieshi to withdraw his troops. Li Jishen in Guangzhou. Wu Tiecheng under house arrest. The whereabouts of Wang Jingwei. Jiang Jieshi forces military police to join the Northern Expedition. Funeral of the mother of Cai Chang, Cai Xing and Cai Cong. Silk industry in Xiangshan county. Bandits on the border of Xiangshan and Xinhui county. Another clan fighting in Dongguan county. | China | http://trove.nla.gov.au/newspaper/page/24101646 | 24101646 |
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]);