This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45825 | 45825 | 1927-06-18 | 7 | a | Australia news/ A Sydney studio is penalised for printing phonographic pictures. A man is detained in Surrey Hills, Sydney, for sexual harassment. Chinese restaurants are advised to pay attention to hygiene issues. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45826 | 45826 | 1927-06-18 | 7 | a | Envoys from Zhang Zuolin and from Jiang Jieshi meet in Dalian. | China | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45827 | 45827 | 1927-06-18 | 7 | a | British embassy in Beijing and its military budget. | Britain | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45828 | 45828 | 1927-06-18 | 7 | a | The war in the Balkan peninsula. | Other... | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45829 | 45829 | 1927-06-18 | 7 | b | The Nanjing government and its policy. | China | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45830 | 45830 | 1927-06-18 | 7 | b | Ferry in Shantou capsized. | China | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45831 | 45831 | 1927-06-18 | 7 | b | A letter from the Chinese National Chamber of Commerce to its Sydney counterpart. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 | |
45832 | 45832 | 1927-06-18 | 7 | c | A letter from Wu Elou (Xiuguang) in Hong Kong reporting his meeting with Ye Tonggui, Huang Huannan, Xia Congzhou and other Chinese businessmen returned from Australia, and the change in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102030 | 24102030 |
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]);