This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45519 | 45519 | 1927-03-05 | 7 | a-b | Australia news/ Rubber factory explodes in Drummoyne, Sydney. An old Chinese gardener dies in an accident. Wale caught in Sydney beach. Chinese gamblers are penalised in Sydney. White women and Chinese men are questioned in Sydney. Election of the New South Wales Chinese Chamber of Commerce and the attendance by Chinese Consul-General Wei Zijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45520 | 45520 | 1927-03-05 | 7 | b | Shanghai commercial chamber seeks to host the exhibition of Chinese Republic. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45521 | 45521 | 1927-03-05 | 7 | b | Foreign banks in Guangzhou and their profit. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45522 | 45522 | 1927-03-05 | 7 | b | Zhang Xueliang on the case of Hankou and Jiujiang. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45523 | 45523 | 1927-03-05 | 7 | c | The International Air Safety Committee. | China | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45524 | 45524 | 1927-03-05 | 7 | c | Soviet Russian authority collect heavy tax on imported leather. | Russia | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45525 | 45525 | 1927-03-05 | 7 | c | Chinese National Chamber of Commerce on the future of Korea and its governor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45526 | 45526 | 1927-03-05 | 7 | e | Advertisement for Kwong Sing War Troupe in the Tivoli Theatre, Castlereagh Street, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
45527 | 45527 | 1927-03-05 | 7 | d | Advertisement for the Government Savings Bank of New South Wales and rural bank. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 |
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]);