This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36416 | 36416 | 1920-12-18 | 8 | a | Chinese Chamber of Commerce in Sydney calls for donations to the famine victims in north China, contact details, and the names listed for donations. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098427 | 24098427 | |
36417 | 36417 | 1920-12-18 | 8 | a-c | Guangdong news/ Lu Rongting agrees to withdraw troops from Zhaoqing. Guangxi people and their attitude towards Guangdong army. Qin Chunxuan resigns and the further report. Guangxi people to suppress Lu Rongting. Guangxi army leave Zhaoqing. Li Jinlun and his effort to mediate the Guangdong disputes. Looting in Beihai. | China | http://trove.nla.gov.au/newspaper/page/24098427 | 24098427 | |
36418 | 36418 | 1920-12-18 | 8 | d | Gold price in Hong Kong. Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098427 | 24098427 |
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]);