This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, 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 | |
| 39628 | 39628 | 1923-03-24 | 2 | b | A cabinet meeting in Beijing chaired by Premier Zhang Shaozeng. | China | http://trove.nla.gov.au/newspaper/page/24094343 | 24094343 | |
| 39629 | 39629 | 1923-03-24 | 2 | b-c | Southeastern provinces may cooperate. | China | http://trove.nla.gov.au/newspaper/page/24094343 | 24094343 | |
| 39630 | 39630 | 1923-03-24 | 2 | c-d | Recent talks by President Li Yuanhong. | China | http://trove.nla.gov.au/newspaper/page/24094343 | 24094343 | |
| 39631 | 39631 | 1923-03-24 | 2 | d-f | Lenin dispatches troops to the border with China. | Other... | http://trove.nla.gov.au/newspaper/page/24094343 | 24094343 | |
| 39632 | 39632 | 1923-03-24 | 2 | f | Further report on the case of Luo Wengan. | China | http://trove.nla.gov.au/newspaper/page/24094343 | 24094343 | |
| 39633 | 39633 | 1923-03-24 | 3 | a | Liang Qichao on the current situations in China. | China | http://trove.nla.gov.au/newspaper/page/24094342 | 24094342 | |
| 39634 | 39634 | 1923-03-24 | 3 | a-b | Wu Peifu on the Guangdong army. | China | http://trove.nla.gov.au/newspaper/page/24094342 | 24094342 | |
| 39635 | 39635 | 1923-03-24 | 3 | c | About 250 high school students are poisoned in Zhejiang province. | America | http://trove.nla.gov.au/newspaper/page/24094342 | 24094342 | |
| 39636 | 39636 | 1923-03-24 | 3 | c | Political development in China and the crisis in Guangdong. | America | http://trove.nla.gov.au/newspaper/page/24094342 | 24094342 | |
| 39637 | 39637 | 1923-03-24 | 3 | d | German territory under the occupation of French army. | Germany | http://trove.nla.gov.au/newspaper/page/24094342 | 24094342 | |
| 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 | |
| 39647 | 39647 | 1923-03-24 | 7 | b | Earthquake in Wellington, New Zealand. | New Zealand | 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]);