This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36070 | 36070 | 1920-09-04 | 2 | a-c | Xian Junhao (John Hoe), businessman from Sydney and now member of the Guangdong provincial legislature and advisor of the provincial government, advocates self-administration of family clans, and his speech. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098293 | 24098293 | |
36072 | 36072 | 1920-09-04 | 2 | c | A letter from military governor of Zhejiang province to the Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098293 | 24098293 | |
36073 | 36073 | 1920-09-04 | 2 | d-e | Chinese citizen in Japan Wang Changchun invents parachute. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098293 | 24098293 | |
36086 | 36086 | 1920-09-04 | 6 | a-c | Third and final part of the report on the Chinese immigration to Samoa. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098299 | 24098299 | |
36087 | 36087 | 1920-09-04 | 7 | a-c | Chinese communities in Samoa have an unprecedented welcome ceremony for the new consul-general Li Nanfang and the detailed report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098298 | 24098298 | |
36088 | 36088 | 1920-09-04 | 7 | c-d | Australia news/ Dock workers on strike in Sydney. A shop burglary in Sydney. Businessman Deng Weixi is leaving Sydney and returning to China. War breaks out in Guangdong. Department store Mark Foy's Ltd in Sydney, the home of good values. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098298 | 24098298 | |
36089 | 36089 | 1920-09-04 | 7 | a | Advertisement for China Trading Company, 54 Dixon Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098298 | 24098298 |
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]);