This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19841 | 19841 | 1908-08-15 | 7 | a | A public notice from Zhenhua company (Jun Wah Sut Yip Co. Ltd) for the sale of shares among Australian Chinese communities and its potential investment in Guangxi, and the agent is Ye Bingnan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801847 | 26801847 | |
19842 | 19842 | 1908-08-15 | 7 | a | Chinese community in New Castle gathers in support of the navy levy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801847 | 26801847 | |
19843 | 19843 | 1908-08-15 | 7 | a | China purchases wool from Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801847 | 26801847 | |
19844 | 19844 | 1908-08-15 | 7 | a | Preparations for the arrival of American naval fleet in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801847 | 26801847 | |
19845 | 19845 | 1908-08-15 | 7 | a | Nine illegal Chinese immigrants detained in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801847 | 26801847 | |
19846 | 19846 | 1908-08-15 | 7 | b | A Chinese man in New South Wales hangs himself in a train and police are now investigating. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801847 | 26801847 | |
19847 | 19847 | 1908-08-15 | 7 | b | Chinese community in Glen Innes celebrates the birthday of Emperor Guangxu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801847 | 26801847 | |
19848 | 19848 | 1908-08-15 | 7 | b | State parliament of New South Wales discusses the opium ban. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801847 | 26801847 | |
19849 | 19849 | 1908-08-15 | 7 | c | American naval fleet to arrive Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801847 | 26801847 | |
19850 | 19850 | 1908-08-15 | 7 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801847 | 26801847 |
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]);