This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33715 | 33715 | 1918-10-12 | 3 | c-d | A report from the border between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24097461 | 24097461 | |
33726 | 33726 | 1918-10-12 | 7 | c-d | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24097465 | 24097465 | |
33731 | 33731 | 1918-10-12 | 8 | c-d | Guangdong news/ Governor Li Yaohan returns to Guangzhou. Long Yuguang in Fujian province and his movements. Restrictions on the sale of official properties. The railway from Guangzhou to Kowloon is still under repaired. Bandits in Dongguan are killed for robbery. Bandits in Shunde county and their kidnaps. Bandits in Gaoming and Xinhui county and their robberies. | China | http://trove.nla.gov.au/newspaper/page/24097468 | 24097468 |
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]);