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 |
---|---|---|---|---|---|---|---|---|---|
45653 | 45653 | 1927-04-30 | 2 | b-c | Editorial by Tung Wah Times on why the United States is so rich. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101964 | 24101964 | |
45673 | 45673 | 1927-04-30 | 7 | a-b | Australia news/ Tung Wah Times comments on good intention and evil intentions. Chinese football team comes to Australia. Chinese gamblers are detained in Sydney. Two ships collide near Brisbane. Editor of Tung Wah Times Wu Elou is returning to China and his farewell party at the Chinese Chamber of Commerce. Loss of a Chinese garden due to the explosion of water pipes. Advertisement report for Wearns Ltd, warehousemen, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101967 | 24101967 | |
45676 | 45676 | 1927-04-30 | 8 | e | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101970 | 24101970 | |
45677 | 45677 | 1927-04-30 | 8 | e | Advertisement for The Commercial Banking Company of Sydney Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101970 | 24101970 | |
45678 | 45678 | 1927-04-30 | 8 | e | Advertisement for The Chinese Chamber of Commerce in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101970 | 24101970 | |
45679 | 45679 | 1927-04-30 | 8 | f | Advertisement for Shanghai Cafe in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101970 | 24101970 |
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]);