This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
44486 | 44486 | 1926-03-06 | 7 | a-d | Australia news/ Court hearing in Melbourne on the injury of Chinese by a well-known actress. Smuggled opium found on board of liner St Albion. Drought in New South Wales and the Chinese gardens. Theatre collapses in blaze in Paddington, Sydney. Message to tax payers. Hand-print cancelled in Cairns, Queensland, for departing Chinese. A small ship travels from Shanghai to Port Darwin. The Zengcheng fellows association in New Zealand welcomes Zhu Songqing, businessman from Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101481 | 24101481 | |
44487 | 44487 | 1926-03-06 | 7 | d | Strike in Japanese silk factory in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101481 | 24101481 | |
44488 | 44488 | 1926-03-06 | 7 | e | Pirates on the coast of Guangdong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101481 | 24101481 | |
44489 | 44489 | 1926-03-06 | 7 | e | Social news from Guangzhou. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24101481 | 24101481 | |
44490 | 44490 | 1926-03-06 | 7 | e | Wu Peifu's strategy towards the communists and his protection of the railway. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101481 | 24101481 |
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]);