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 |
---|---|---|---|---|---|---|---|---|---|
13684 | 13684 | 1904-08-20 | 2 | a-b | First part of Liang Qichao's article, The Future of Guangdong. Current situation in Guangdong. Number of Cantonese people in America, Australia, Hawaii, the Philippines, Central and South America, Canada, Mexico, and other regions. How much they earn, how much they send back to Guangdong, and the total number. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800505 | 26800505 | |
13701 | 13701 | 1904-08-20 | Suppl't | a-b | Chinese communities in Sydney are being organised to protect their business activities. Report on a gathering and speeches by Liu Ruxing, Chen Xia, Xian Junhao, and Liang Chuang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800506 | 26800506 | |
13702 | 13702 | 1904-08-20 | Suppl't | b | Report on a debate in Sydney between Chinese businessman Chen Xia and a White man on 'White Australia' immigration regulations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800506 | 26800506 | |
13703 | 13703 | 1904-08-20 | Suppl't | b | Labour Party has been defeated in the State election. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800506 | 26800506 | |
13704 | 13704 | 1904-08-20 | Suppl't | b | A Japanese liner arrives in Sydney; report on the welcoming ceremony. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800506 | 26800506 | |
13707 | 13707 | 1904-08-20 | Suppl't | c | Tung Wah Times thanks those who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800506 | 26800506 |
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]);