This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20639 | 20639 | 1909-02-13 | 2 | a | Chinese businessmen in Sydney call for donation to flood victims in Enping, Kaiping, Xinning, Xinhui, Gaoyao, Gaoming, Heshan and Xinxing counties of Guangdong. They are On Chong & Co. at 223 George Street, Sun Hing Jang & Co. at 429 Pitt Street, Kwong War Chong & Co. at 46 Campbell Street, Hang Hi Hop Kee & Co on Pitt Street, Tung Wah Times at 158 George Street, Tiy Sang on Campbell Street, Wing Sang on 18-22 Campbell Street, Wing On at 24 Campbell Street, and Sun Suey Wah at 73-77 Campbell Street. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802076 | 26802076 | |
20657 | 20657 | 1909-02-13 | 7 | a | Important news/ Yuan Shikai removed. Jiang Chunlin impeaches Yuan Shikai. Yang Shixiang might become governor of Zhili province. Yuan Shikai after being removed. Foreign missions in Beijing inquire into the removal of Yuan Shikai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802079 | 26802079 | |
20658 | 20658 | 1909-02-13 | 7 | a | German steamship company in Sydney entertains Chinese businessmen including Ye Bingnan and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802079 | 26802079 |
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]);