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 |
|---|---|---|---|---|---|---|---|---|---|
| 39254 | 39254 | 1923-01-13 | 2 | a-b | Editorial on the bomb blast in Guangzhou and the arrest of Luo Wengan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094252 | 24094252 | |
| 39270 | 39270 | 1923-01-13 | 7 | a | A letter from Jin Boshun and Wang Zuyao, of the Zhejiang Commercial association in Hangzhou, and Lu Yongxiang and Shen Jinjian, of the Zhejiang government, appeals for help to the flooding victims in Zhejiang province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094255 | 24094255 | |
| 39272 | 39272 | 1923-01-13 | 7 | b-c | Ye Bingnan's daughter Ye Meigui marries Luo Weixin, son of another businessman in Sydney Luo Daren. Report on the wedding and the banquet. Speakers include Liu Guangfu, Zhu Hechou, Luo Weixin, Lin Dasan, Wu Elou, Liu Bingshu, Chen Lin, and other white guests. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094255 | 24094255 | |
| 39273 | 39273 | 1923-01-13 | 7 | c | Chinese sailors on board of a foreign cargo ship fight in Sydney and the injury. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094255 | 24094255 | |
| 39277 | 39277 | 1923-01-13 | 7 | c-d | Chinese passenger is detained in Port Darwin for opium smuggling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094255 | 24094255 | |
| 39278 | 39278 | 1923-01-13 | 7 | d | Sydney customs officer finds smuggled opium in a Dutch ship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094255 | 24094255 | |
| 39279 | 39279 | 1923-01-13 | 7 | d | A Chinese businessman, who flees Western Australia for debt, has committed suicide in Parramatta, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094255 | 24094255 | |
| 39280 | 39280 | 1923-01-13 | 7 | d | A Chinese employee of the He Lee fruit shop in Sydney commits suicide. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094255 | 24094255 | |
| 39281 | 39281 | 1923-01-13 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094255 | 24094255 | |
| 39282 | 39282 | 1923-01-13 | 8 | a-d | Guangdong news/ Sun Yatsen's troops return to Guangdong. Guangdong army in Guangxi and their defence plan. Report from the frontline in Guangxi. Guangdong governor Chen Xiru wants to conclude the negotiation with Portuguese authority for the Macao issues. Wong Shiliang is training his troops in Chaozhou. Ammunition factory is to resume production in Zhaoqing. Journalism association to be set up in Guangzhou. Chen Jiongming to ban opium smoking and gambling in the counties. News from Fujian province. A Portuguese ship is hijacked near Macao and the solution. Robbery in Xiangshan county. A martial arts girl beats three young men. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094258 | 24094258 | |
| 39283 | 39283 | 1923-01-13 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094258 | 24094258 | |
| 39284 | 39284 | 1923-01-13 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094258 | 24094258 |
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]);