This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8066 | 8066 | 1901-07-03 | 2 | c | British government considers returning the railway to China. | China | http://trove.nla.gov.au/newspaper/page/24100097 | 24100097 | |
8067 | 8067 | 1901-07-03 | 2 | c | China changes the etiquette practiced when meeting and entertaining foreign envoys. | China | http://trove.nla.gov.au/newspaper/page/24100097 | 24100097 | |
8068 | 8068 | 1901-07-03 | 2 | c | Temporary lodge in Xi'an discusses some key issues with Zhang Zhidong and Liu Kunyi. | China | http://trove.nla.gov.au/newspaper/page/24100097 | 24100097 | |
8069 | 8069 | 1901-07-03 | 2 | c | Independent kingdoms suggested for different regions of China. | China | http://trove.nla.gov.au/newspaper/page/24100097 | 24100097 | |
8070 | 8070 | 1901-07-03 | 2 | c | Zhang Zhidong prepares to establish a newspaper under the proposed new policies. | China | http://trove.nla.gov.au/newspaper/page/24100097 | 24100097 | |
8071 | 8071 | 1901-07-03 | 2 | c | France plans to build more railways in Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24100097 | 24100097 | |
8091 | 8091 | 1901-07-03 | 3 | c | Zhang Zhidong's comments on the Empress during his meeting with British consul general in Hankou. | Australia | http://trove.nla.gov.au/newspaper/page/24100096 | 24100096 | |
8092 | 8092 | 1901-07-03 | 3 | c | Prince of Britain and his wife have left New Zealand for Tasmania. | Australia | http://trove.nla.gov.au/newspaper/page/24100096 | 24100096 | |
8093 | 8093 | 1901-07-03 | 3 | c | A British ship ran onto rocks, endangering the lives of those on board. | Australia | http://trove.nla.gov.au/newspaper/page/24100096 | 24100096 |
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]);