This data as json, CSV (advanced)
Suggested facets: page, description, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27892 | 27892 | 1913-09-20 | 3 | c | Foreign countries and the salt sale in China. | China | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27893 | 27893 | 1913-09-20 | 3 | c | China seeks to recruit some Germany military officers and response of the international community. | Britain | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27894 | 27894 | 1913-09-20 | 3 | c | Murderers in Tokyo who assassinated Japanese foreign ministry official are executed. | Japan | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27895 | 27895 | 1913-09-20 | 3 | c | Clash between the Monarchists and the Republicans in Portugal. | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | ||
27900 | 27900 | 1913-09-20 | 7 | c | Relations between China and Japan deteriorate following the Nanjing incident. | Britain | http://trove.nla.gov.au/newspaper/page/24092828 | 24092828 | |
27901 | 27901 | 1913-09-20 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092828 | 24092828 | |
27902 | 27902 | 1913-09-20 | 7 | c | Farewell message by Gao Tao on his departure for China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092828 | 24092828 | |
27903 | 27903 | 1913-09-20 | 7 | c | A Chinese market garden in New South Wales seeks to recruit a labourer. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092828 | 24092828 | |
27909 | 27909 | 1913-09-20 | 8 | c | Guangdong news/ Long Jiguang takes the office of military governorship. Loss caused by the clash between Long Jiguang and Chen Jiongming. Chen Jiongming injures his mother. Zhong Rongguang farewells Chen Jiongming. Long Jiguang is trapped by Chen Jinghua. | China | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 | |
27910 | 27910 | 1913-09-20 | 8 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 |
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]);