This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8043 | 8043 | 1901-06-29 | 2 | f | Hundreds of Italian workers in France were deported. | Australia | http://trove.nla.gov.au/newspaper/page/24100093 | 24100093 | |
8044 | 8044 | 1901-06-29 | 2 | f | It is rumoured that the land in Zhaoqing has a crack. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100093 | 24100093 | |
8045 | 8045 | 1901-06-29 | 2 | f | Magistrate of Gaoming county has some advice for foreign missionary workers, | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100093 | 24100093 | |
8046 | 8046 | 1901-06-29 | 2 | f | The third part of an official note presented to the Chinese government by ambassadors from America, France, Japan, Britain, Belgium, Italy, Austria, Germany and the Netherlands, which requires Chinese government to punish all those who were in collusion with the Boxers. A list of Chinese officials who colluded with the Boxers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100093 | 24100093 |
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]);