This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45513 | 45513 | 1927-03-05 | 2 | c-d | Editorial on the hope of peace in China between the south and the north. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101900 | 24101900 | |
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 | |
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 | |
45530 | 45530 | 1927-03-05 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 | |
45531 | 45531 | 1927-03-05 | 8 | e | Advertisement for the New South Wales Chinese Chamber of Commerce. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 | |
45532 | 45532 | 1927-03-05 | 8 | f | Advertisement for Shanghai Cafe, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 | |
45533 | 45533 | 1927-03-05 | 8 | f | Advertisement for Hop Lee & Co, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101906 | 24101906 |
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]);