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 |
---|---|---|---|---|---|---|---|---|---|
27642 | 27642 | 1913-07-26 | 2 | a | Special notice issued by the Chinese Empire Reform Association in Sydney on name change, and the new name will be the Nationalist Association (bing wu guo min dang), 158 George Street North, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092761 | 24092761 | |
27648 | 27648 | 1913-07-26 | 3 | a | Guangdong businessmen in Hong Kong condemns rebellions like Hu Hanmin, Liao Zhongkai and Chen Jinghua. | China | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27649 | 27649 | 1913-07-26 | 3 | a | An attempt to assassinate the President of Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27650 | 27650 | 1913-07-26 | 3 | a | Boycott to Chinese fruit business in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27651 | 27651 | 1913-07-26 | 3 | a | The second revolutionary wave arrives in China following independence of Jiangxi, Jiangsu, Guangxi, Fujian, Sichuan, Anhui, Hunan and Guangdong provinces. | China | http://trove.nla.gov.au/newspaper/page/24092760 | 24092760 | |
27658 | 27658 | 1913-07-26 | 6 | a | The New South Wales Chinese Chamber of Commerce announces its formal establishment and the address is 158 George Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092765 | 24092765 |
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]);