This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27885 | 27885 | 1913-09-20 | 3 | b | Four Japanese warships arrive Nanjing. | Britain | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27886 | 27886 | 1913-09-20 | 3 | b | Japan demands compensation from Chinese government for their loss or insult suffered in Shandong, Hankou, and Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27887 | 27887 | 1913-09-20 | 3 | b | Zhang Xun and his army in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27888 | 27888 | 1913-09-20 | 3 | b | China has new cabinet under Xiong Xiling, and his ministers include Zhang Qian, Liang Qichao and Sun Baoqi. | China | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27889 | 27889 | 1913-09-20 | 3 | b | Peace talks between Turkey and Bulgaria. | Other... | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27890 | 27890 | 1913-09-20 | 3 | b | Two islands near Tonga vanish. | America | http://trove.nla.gov.au/newspaper/page/24092824 | 24092824 | |
27905 | 27905 | 1913-09-20 | 8 | b | China and Russia may have clash on the Mongolian issues. | Germany | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 | |
27906 | 27906 | 1913-09-20 | 8 | b | Tang Caizhi writes to his nephew, son of Tang Caichang. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 | |
27907 | 27907 | 1913-09-20 | 8 | b | Rebellions in Guangdong and Fujian province and their backgrounds. | China | 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]);