This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37348 | 37348 | 1921-07-16 | 8 | a | Chinese communities in New Zealand donate to the famine victims in north China. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093619 | 24093619 | |
37349 | 37349 | 1921-07-16 | 8 | a-c | Guangdong news/ Sun Yatsen wins more power for his presidency. How Chen Jiongming raises funds for his army. Li Houji is not happy with Sun Yatsen. The influence of New Culture promoted by Chen Duxiu. Water level falls in Zhaoqing. Two boys and one girl at a birth in Zhaoqing. Police solders in Guangzhou and the house search. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093619 | 24093619 | |
37350 | 37350 | 1921-07-16 | 8 | c | Advertisement for the China-Australia Mail S. S. Line. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093619 | 24093619 | |
37351 | 37351 | 1921-07-16 | 8 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093619 | 24093619 |
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]);