This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 39301 | 39301 | 1923-01-20 | 7 | a | A bank manager is arrested in New South Wales for misconduct. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
| 39302 | 39302 | 1923-01-20 | 7 | a | A fisherman in Redfern, Sydney, is punished for the capture of fish that are too small. | Australia | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
| 39303 | 39303 | 1923-01-20 | 7 | a | A thief suspect is detained in Sydney for burglary. | Australia | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
| 39304 | 39304 | 1923-01-20 | 7 | a | A Melbourne woman shoots dead her husband for divorce. | Australia | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
| 39305 | 39305 | 1923-01-20 | 7 | a-b | A new-born baby is found abandoned in the bush near Melbourne. | Australia | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
| 39306 | 39306 | 1923-01-20 | 7 | b | Three woman workers are killed in an explosion of Melbourne ammunition factory. | Australia | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
| 39307 | 39307 | 1923-01-20 | 7 | b | Chen Jiongming arrives Huizhou. | China | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
| 39308 | 39308 | 1923-01-20 | 7 | b | News in brief/ Gu Weijun is back to his ambassador office in London. Transportation is suspended in Yichang and Chongqing. Wang Zhengting is the acting premier. Zhang Shaozeng, Wu Jinglian, Li Houji, Wang Xianchen and the cabinet organisation in Beijing. Lu Zhengxiang reports from the League of Nations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
| 39309 | 39309 | 1923-01-20 | 7 | c | Chinese community in New Zealand donates to the typhoon victims in Shantou, reported by the Chinese Association there. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
| 39310 | 39310 | 1923-01-20 | 7 | c | A notice by the Chinese Chamber of Commerce in New South Wales regarding the membership, registration and other issues of the association. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
| 39311 | 39311 | 1923-01-20 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 |
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]);