This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36899 | 36899 | 1921-04-23 | 8 | a-b | First group of receipts issued by the Chinese ministry of foreign affairs acknowledge donations by overseas Chinese communities (in various countries) to the famine victims in north China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093523 | 24093523 | |
36900 | 36900 | 1921-04-23 | 8 | b | Guangdong news/ It is rumoured that Wei Bangping tries to assassinate Hong Zhaolin. Further report on the attempt to assassinate Hong Zhaolin. Guangdong businessmen in Shanghai criticise Chen Duxiu, educational commissioner in Guangzhou, for his communist speeches, and the reply from governor Chen Jiongming. Tang Jiyao will stay in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093523 | 24093523 | |
36901 | 36901 | 1921-04-23 | 8 | c | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093523 | 24093523 |
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]);