This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20400 | 20400 | 1908-12-19 | 6 | a | Correspondence from Beijing on Yuan Shikai's secret motives and ambition. | China | http://trove.nla.gov.au/newspaper/page/26801992 | 26801992 | |
20401 | 20401 | 1908-12-19 | 6 | a-b | Report from Xiamen (Amoy) on the welcome ceremony on the arrival of America naval fleet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801992 | 26801992 | |
20402 | 20402 | 1908-12-19 | 6 | b-c | Russian government borrows foreign loans. Turkish government seeks assistance from Britain on the development of its navy. Italian government increases funding to navy. Yuan Shikai in the court and his power. | Britain | http://trove.nla.gov.au/newspaper/page/26801992 | 26801992 | |
20403 | 20403 | 1908-12-19 | 6 | c | Most immigration agencies are closed in Japan following the ban by Japanese government to send labourers overseas. | Japan | http://trove.nla.gov.au/newspaper/page/26801992 | 26801992 | |
20404 | 20404 | 1908-12-19 | 6 | c | Bandits in St Petersburg publish their own newspaper. | Russia | http://trove.nla.gov.au/newspaper/page/26801992 | 26801992 | |
20405 | 20405 | 1908-12-19 | 6 | c | Britain, America and Japan to meet and discuss possible alliance. | Japan | http://trove.nla.gov.au/newspaper/page/26801992 | 26801992 | |
20406 | 20406 | 1908-12-19 | 6 | c | Russian ambassador in Washington refuses to issue visa to a Jewish businessman. | America | http://trove.nla.gov.au/newspaper/page/26801992 | 26801992 |
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]);