This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 37141 | 37141 | 1921-06-25 | 2 | a-b | Editorial on malfunctions of a political party. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093589 | 24093589 | |
| 37142 | 37142 | 1921-06-25 | 2 | b-c | Third part of the proposal to improve the quality of China products, written by Lu Huayue. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093589 | 24093589 | |
| 37143 | 37143 | 1921-06-25 | 2 | c | Lu Rongting will lead the army to suppress Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24093589 | 24093589 | |
| 37144 | 37144 | 1921-06-25 | 2 | c-d | Armed conflict between Guangdong and Guangxi may break out at any moment. And comparison of Guangxi and Guangdong armies. | China | http://trove.nla.gov.au/newspaper/page/24093589 | 24093589 | |
| 37145 | 37145 | 1921-06-25 | 2 | d | American government will not support Sun Yatsen. | America | http://trove.nla.gov.au/newspaper/page/24093589 | 24093589 | |
| 37146 | 37146 | 1921-06-25 | 2 | d | Hong Kong authority (Chinese Affairs Office) forbids any fundraising for Sun Yatsen. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093589 | 24093589 | |
| 37147 | 37147 | 1921-06-25 | 2 | d | A telegram from Wang Zongyao to Xu Qian. | China | http://trove.nla.gov.au/newspaper/page/24093589 | 24093589 | |
| 37148 | 37148 | 1921-06-25 | 3 | a-b | A circular telegram issued by Lu Rongting. | China | http://trove.nla.gov.au/newspaper/page/24093588 | 24093588 | |
| 37149 | 37149 | 1921-06-25 | 3 | b-c | Lu Rongting's request to wipe out Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24093588 | 24093588 | |
| 37150 | 37150 | 1921-06-25 | 3 | c | Troops from Fujian, Jiangxi and Guangxi are ready to attack Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24093588 | 24093588 | |
| 37151 | 37151 | 1921-06-25 | 3 | c | Beijing municipal government to borrow loans from France in order to build tram lines. | China | http://trove.nla.gov.au/newspaper/page/24093588 | 24093588 | |
| 37152 | 37152 | 1921-06-25 | 3 | c | Sun Yatsen seeks recognition from American government. | America | http://trove.nla.gov.au/newspaper/page/24093588 | 24093588 | |
| 37153 | 37153 | 1921-06-25 | 3 | c | American government to organise a Pacific Fleet. | America | http://trove.nla.gov.au/newspaper/page/24093588 | 24093588 | |
| 37154 | 37154 | 1921-06-25 | 3 | c | New York police seize huge amount of weapons on board of a ship bound for Ireland. | America | http://trove.nla.gov.au/newspaper/page/24093588 | 24093588 | |
| 37155 | 37155 | 1921-06-25 | 3 | d | A notice by Liu Yufang, on behalf of an iron company in America, to its Chinese shareholders in Australia in regards to the company bankruptcy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093588 | 24093588 | |
| 37156 | 37156 | 1921-06-25 | 6 | a | Chinese delegate Gu Weijun puts forwards the Shandong problem to the League of Nations. | China | http://trove.nla.gov.au/newspaper/page/24093593 | 24093593 | |
| 37157 | 37157 | 1921-06-25 | 6 | a-c | Contents of a secret treaty signed between China (Chinese ambassador to Japan Zhang Zongxiang) and Switzerland. | Other... | http://trove.nla.gov.au/newspaper/page/24093593 | 24093593 | |
| 37158 | 37158 | 1921-06-25 | 7 | a | Chinese Chamber of Commerce to gather and welcome Guo Shun. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37159 | 37159 | 1921-06-25 | 7 | a | Earthquake in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37160 | 37160 | 1921-06-25 | 7 | a | Four illegal Chinese migrants are detained from a market garden in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37161 | 37161 | 1921-06-25 | 7 | a | Camel kills a baby during circus performance. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37162 | 37162 | 1921-06-25 | 7 | a | Another arrest in Sydney for opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37163 | 37163 | 1921-06-25 | 7 | a | A big star in the sky that can be seen in Sydney and Glen Innes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37164 | 37164 | 1921-06-25 | 7 | a-b | A group of gamblers detained in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37165 | 37165 | 1921-06-25 | 7 | b | American parliamentarians are closely watching Japanese and British in China. | America | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37166 | 37166 | 1921-06-25 | 7 | b | Flood in Tokyo. | Japan | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37167 | 37167 | 1921-06-25 | 7 | b | Britain and Japan will renew their alliance treaty for another three months. | America | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37168 | 37168 | 1921-06-25 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37169 | 37169 | 1921-06-25 | 7 | c | A notice issued the Sun & Co Ltd in Hong Kong to its shareholders for dividends | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093592 | 24093592 | |
| 37170 | 37170 | 1921-06-25 | 8 | c | A letter from Guangzhou Chamber of Commerce to the Chinese Chamber of Commerce in New South Wales. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093595 | 24093595 | |
| 37171 | 37171 | 1921-06-25 | 8 | a-b | Guangdong news/ A prominent gentry in Guangzhou comments on current situations. Chen Jiongming supports a simple life association (jian de hui). Chen Jiongming abolishes ferry tax imposed by Zengcheng authority. Local security troops and the training in Zengcheng. Treasure found inside of a Buddha statue. A strange omen in a hill near Guangzhou. Bandits in Dongguan and the robbery. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093595 | 24093595 | |
| 37172 | 37172 | 1921-06-25 | 8 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093595 | 24093595 | |
| 37173 | 37173 | 1921-06-25 | 8 | c | A notice by the China-Australia Mail Line to its shareholders. | http://trove.nla.gov.au/newspaper/page/24093595 | 24093595 |
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]);