This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28969 | 28969 | 1914-06-20 | 3 | d | Chinese engineers and workers arrives America on their way to prepare for the Panama Exhibition, and American authority collects duties on their rice. | America | http://trove.nla.gov.au/newspaper/page/24093147 | 24093147 | |
28970 | 28970 | 1914-06-20 | 3 | d | Air show in London and report on some new world records. | Britain | http://trove.nla.gov.au/newspaper/page/24093147 | 24093147 | |
28971 | 28971 | 1914-06-20 | 3 | d | Beijing news/ President Yuan Shikai and Premier Xu Shichang have a secret talk. Premier Xu Shichang will not be paid in order to save some money for the country. Xu Shichang and Liang Dunyan in Beijing. Talks on the Tibet issues between China, Britain and Tibet. | China | http://trove.nla.gov.au/newspaper/page/24093147 | 24093147 |
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]);