This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 39271 | 39271 | 1923-01-13 | 7 | a-b | Australian trade commissioner to China Edward Little on trade between the two countries. | Australia | 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 | |
| 39274 | 39274 | 1923-01-13 | 7 | c | A city council employee in Albury, Victoria, is injured by a shaver manufactured in Japan. | Australia | http://trove.nla.gov.au/newspaper/page/24094255 | 24094255 | |
| 39275 | 39275 | 1923-01-13 | 7 | c | Bush fire in Goulburn, New South Wales. | Australia | http://trove.nla.gov.au/newspaper/page/24094255 | 24094255 | |
| 39276 | 39276 | 1923-01-13 | 7 | c | A clothes shop in King Street, Sydney, is burglarised. | Australia | 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 |
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]);