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 |
---|---|---|---|---|---|---|---|---|---|
20818 | 20818 | 1909-03-20 | 7 | a | Chinese community in Sydney thanks the outgoing governor of New South Wales, Harry Johnson, and the message from the governor. Representatives of the Chinese community are Ye Bingnan, Zhou Rongwei, Li Chun, Wu Shihua an Xian Junhao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802119 | 26802119 | |
20819 | 20819 | 1909-03-20 | 7 | a | The first Chinese consul general to Australia Liang Lanxun has arrived in Perth, and his talk to English journalist on the relations between China and Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802119 | 26802119 | |
20829 | 20829 | 1909-03-20 | 8 | a | Guangmei Agriculture and Husbandry Company (Guangmei nong mu gong si) in Guangxi province calls for investment from overseas Chinese communities, and a public notice from its agent Zhang Junrong (George Gun Wing), storekeeper in Dalby, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802121 | 26802121 |
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]);