This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
39238 | 39238 | 1923-01-06 | 7 | a | New South Wales government issues new regulation on gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39239 | 39239 | 1923-01-06 | 7 | a | A department store in Sydney on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39240 | 39240 | 1923-01-06 | 7 | a-b | Two men in Sydney are detained for rape. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39241 | 39241 | 1923-01-06 | 7 | b | Motorbike association to be organised in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39242 | 39242 | 1923-01-06 | 7 | b-c | Chinese passengers on board of St Albans refuse to provide hand-print in Cairns, Queensland. Chinese Chamber of Commerce in New South Wales investigates and supports the Australian government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39243 | 39243 | 1923-01-06 | 7 | c | Result of the federal election and composition of the new House of Representatives. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39244 | 39244 | 1923-01-06 | 7 | c | Melbourne welcomes the visit of French warships. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39245 | 39245 | 1923-01-06 | 7 | c | A man's body found in Sydney Zoo. | Australia | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39246 | 39246 | 1923-01-06 | 7 | c | Guangdong has recognised the Beijing government. | China | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39247 | 39247 | 1923-01-06 | 7 | c-d | News in brief/ Wang Daxie to resign. Li Yuanhong seeks support for the new cabinet. Japan withdraws its postal service. Wang Daxie has resigned. Cao Kun replies to Li Yuanhong. Agreement signed on the return of Shandong. Wedding of Emperor Xuantong. | China | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39248 | 39248 | 1923-01-06 | 7 | d | A notice by the Chinese Chamber of Commerce says Chinese passenger Yang Jingquan disappears on the way back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39249 | 39249 | 1923-01-06 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 | |
39250 | 39250 | 1923-01-06 | 7 | e | A notice by the China-Australia Steamship Mail Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094247 | 24094247 |
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]);