This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
40268 | 40268 | 1923-08-18 | 8 | a | Executive Manager of the Tung Wah Times Zhang Maokuan calls for donations to the building of Confucian temple. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094518 | 24094518 | |
40269 | 40269 | 1923-08-18 | 8 | a-d | Guangdong news/ Muslim mosques and Buddhist temples in Guangzhou will not be auctioned. Farewell message from the Chinese Survey Engineering Society to the Chinese football team on their leaving for a visit to Australia. Disaster of war in Zhaoqing is followed by typhoon. Battle report from Chaozhou and Shantou. Sun Yatsen order to attack Huizhou. Wang Yuguang and other thousands of people issue a circular telegram that request Sun Yatsen to leave. Flood in Gaoyao county. Sun Yatsen wants to collect more from Ningyang railway company. Sun Ke extorts money from every businessman in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094518 | 24094518 | |
40270 | 40270 | 1923-08-18 | 8 | e | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094518 | 24094518 | |
40271 | 40271 | 1923-08-18 | 8 | e | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094518 | 24094518 |
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]);