This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46818 | 46818 | 1928-03-10 | 5 | a | Hong Kong news/ Guangdong provincial government seeks to borrow loans from Hong Kong sources. Further report on the case of Wang Zongzhu. Another suicide for love on the ferry from Guangzhou to Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24098721 | 24098721 | |
46819 | 46819 | 1928-03-10 | 5 | b | First part of a survey on the shops destroyed during the Communist catastrophe and their losses. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098721 | 24098721 | |
46820 | 46820 | 1928-03-10 | 5 | c | First part of a survey on the wax industry in Sichuan province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098721 | 24098721 |
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]);