This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 39872 | 39872 | 1923-05-19 | 7 | a | A notice by Cai Chang, general manager of The Sun company in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094411 | 24094411 | |
| 39873 | 39873 | 1923-05-19 | 7 | a | A thief is caught on the site in Ashfield, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094411 | 24094411 | |
| 39874 | 39874 | 1923-05-19 | 7 | a | A Chinese businessman in Queensland is penalised for selling wine without licence. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094411 | 24094411 | |
| 39875 | 39875 | 1923-05-19 | 7 | b | Victoria, a liner of the China-Australia Steamship Line, arrives Sydney with 238 passengers and their destinations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094411 | 24094411 | |
| 39876 | 39876 | 1923-05-19 | 7 | b | Chinese and Japanese gamblers are detained in Hay Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094411 | 24094411 | |
| 39877 | 39877 | 1923-05-19 | 7 | b | Two cashiers (of the Flinders Street Station, Melbourne) are robbed. | Australia | http://trove.nla.gov.au/newspaper/page/24094411 | 24094411 | |
| 39878 | 39878 | 1923-05-19 | 7 | b | Pirates hijack a cargo ship from Hong Kong to Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24094411 | 24094411 | |
| 39879 | 39879 | 1923-05-19 | 7 | b-c | News in brief/ Emperor Xuantong sends envoy to meet President Li Yuanhong. Chinese ambassadors in Europe send telegram to Beijing on the negotiation with Japan. A telegram from Zhang Shaozeng cabinet in Beijing to Sun Yatsen in Guangzhou. Sichuan, Hunan, Yunnan and Guizhou to defend their alliance. Zhang Shaozeng and Li Yuanhong on Fujian issues. Navy in Shanghai declares neutral. Sun Chuanfang arrives Fuzhou. Wu Peifu's troops arrive Rehe. Cao Kun and Feng Yuxiang on the Fengtian issues. Sun Yatsen replies to Li Yuanhong and Zhang Shaozeng. President Li Yuanhong on the murder of naval commander Cheng Biguang. Naval fleets gather in Shanghai. Military situation in Sichuan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094411 | 24094411 | |
| 39880 | 39880 | 1923-05-19 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094411 | 24094411 |
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]);