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 |
|---|---|---|---|---|---|---|---|---|---|
| 39627 | 39627 | 1923-03-24 | 2 | a-b | Second and final part of an article, written by anonymous author, on the Chinese in White Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094343 | 24094343 | |
| 39638 | 39638 | 1923-03-24 | 6 | a | Comments by anonymous author on the anti-Chinese articles published in the Sydney English newspapers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094347 | 24094347 | |
| 39639 | 39639 | 1923-03-24 | 6 | a-b | Article written by anonymous author on Yu Rong, secretary of the Nationalist Party (Guomindang) branch in Sydney and publisher of the Min Bao. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094347 | 24094347 | |
| 39640 | 39640 | 1923-03-24 | 6 | b-c | Let me awaken editor of the Min Bao, a Chinese newspaper in Sydney owned and published by the Nationalist Party (Guomindang). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094347 | 24094347 | |
| 39641 | 39641 | 1923-03-24 | 6 | c-d | Another reply by the Tung Wah Times to criticism by Min Bao in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094347 | 24094347 | |
| 39642 | 39642 | 1923-03-24 | 7 | a | Report on election result of the Chinese Chamber of Commerce in New South Wales. Names listed for all candidates. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094346 | 24094346 | |
| 39643 | 39643 | 1923-03-24 | 7 | a-b | Industrial development in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094346 | 24094346 | |
| 39644 | 39644 | 1923-03-24 | 7 | b | Timely rain in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094346 | 24094346 | |
| 39645 | 39645 | 1923-03-24 | 7 | b | Retailers association in Sydney decides to close shops during the Easter holiday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094346 | 24094346 | |
| 39646 | 39646 | 1923-03-24 | 7 | b | More than 100 white gamblers are arrested in Pyrmont, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094346 | 24094346 | |
| 39648 | 39648 | 1923-03-24 | 7 | b-c | Comments on the editor of Min Bao in Sydney by anonymous author. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094346 | 24094346 | |
| 39649 | 39649 | 1923-03-24 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094346 | 24094346 | |
| 39650 | 39650 | 1923-03-24 | 7 | c | Farewell message by Zhou Linyou on his return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094346 | 24094346 | |
| 39651 | 39651 | 1923-03-24 | 8 | a-d | Guangdong news/ Sun Yatsen to set up Marshall Headquarters in Guangzhou. Xu Shaozheng becomes the provincial governor. Sun Yatsen convenes conferences in Guangzhou to solve the Guangdong problems. Train from Guangzhou to Kowloon is hijacked. Military news from Zhaoqing. Looting in Shilong town. Disasters in Zhaoqing brought by the troops. Wang Jingwei might go to Shanghai again. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094349 | 24094349 | |
| 39652 | 39652 | 1923-03-24 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094349 | 24094349 | |
| 39653 | 39653 | 1923-03-24 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094349 | 24094349 |
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]);