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 |
---|---|---|---|---|---|---|---|---|---|
31020 | 31020 | 1916-03-11 | 3 | c | Chinese government may have to reject imperial system. | China | http://trove.nla.gov.au/newspaper/page/24095186 | 24095186 | |
31021 | 31021 | 1916-03-11 | 3 | c | A big British business ship is sunken by an underwater mine in British sea, resulting in many casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24095186 | 24095186 | |
31022 | 31022 | 1916-03-11 | 3 | c | A French personnel transporting warship sank in Mediterranean Sea, resulting in many casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24095186 | 24095186 | |
31030 | 31030 | 1916-03-11 | 6 | c | Guangdong news/A person with family name Yuan asks Guangdong government support him to Beijing, celebrating Yuan Shikai's coming to throne. Li Yaohan asks to be rewarded for investigating clues of revolutionary party's activities. Long Jiguang orders to close a ship company which is involved with revolutionary party. | China | http://trove.nla.gov.au/newspaper/page/24095191 | 24095191 | |
31034 | 31034 | 1916-03-11 | 8 | c | Poems of Yi Soushi, Zhou Yufang and Qian Ren. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095193 | 24095193 |
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]);