This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27970 | 27970 | 1913-10-04 | 8 | a | A Guangzhou newspaper comments on the current Chinese affairs. | China | http://trove.nla.gov.au/newspaper/page/24092847 | 24092847 | |
27971 | 27971 | 1913-10-04 | 8 | a-b | A filial son, Cao Jiaju, finds his father and the story. | China | http://trove.nla.gov.au/newspaper/page/24092847 | 24092847 | |
27972 | 27972 | 1913-10-04 | 8 | b | Political chaos in Mongolia and the conflict between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24092847 | 24092847 | |
27973 | 27973 | 1913-10-04 | 8 | b-c | Guangdong news/ Wang Shengling is appointed to manage civil affairs in Guangdong. Huang Shilong to see doctor in Hong Kong. Naval commander Liu Guanxiong is going south on inspection. Dyke in Shunde county may break. Huang Shilong is approved to see doctor in Hong Kong. Zhong Rongguang is rebuffed. | China | http://trove.nla.gov.au/newspaper/page/24092847 | 24092847 |
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]);