This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4470 | 4470 | 1900-01-20 | 2 | a-b | A letter, written by anonymous author, from Xin'an county, Guangdong, to the Chinese community in Sydney, advocating the establishment of a Chinese Empire Reform Association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4471 | 4471 | 1900-01-20 | 2 | b-c | A letter from Chinese Empire Reform Association in Canada to the Chinese community in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4472 | 4472 | 1900-01-20 | 2 | d | Negotiations and fights between China and France in the Guangzhou Bay. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4473 | 4473 | 1900-01-20 | 2 | d | Ways to manufacture and use rubber. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4474 | 4474 | 1900-01-20 | 2 | d | Confucian temples and societies are being set up in Nanyang Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4475 | 4475 | 1900-01-20 | 2 | d | France requests two more regions outside Beijing from the Chinese government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4476 | 4476 | 1900-01-20 | 2 | d-e | Reports on the war between Britain and Transvaal in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4477 | 4477 | 1900-01-20 | 2 | e | Guangzhou offered rewards for the capture of four bandits who robbed a shop. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4478 | 4478 | 1900-01-20 | 2 | f | Japanese custom officials visit Queensland, New South Wales and Victoria. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 |
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]);