This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24154 | 24154 | 1911-01-14 | 3 | a | Crown coronation for the British King and a British colonies meeting | A meeting with British's colonies will be hosted by the then Prime Minister. This meeting coincides with the crown coronation for the British King. | Britain | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
24155 | 24155 | 1911-01-14 | 3 | a | London's anarchist party | The headquarter of the anarchist party was destroyed by the police. | Britain | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
24156 | 24156 | 1911-01-14 | 3 | a | A survey on British-made vessels | A survey of the number of British-made vessels. | Britain | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
24158 | 24158 | 1911-01-14 | 3 | a | Russia, German, and Persia | A secret deal between Russia and German on how to take advantage of Persia. | Britain | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
24160 | 24160 | 1911-01-14 | 3 | b | Loan for Nanman Railway | The Japanese government loaned money from the British to build Nanman Railway. | Britain | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
24161 | 24161 | 1911-01-14 | 3 | b | The British prince will attend university | This fall the British prince will attend the (?) University. | Britain | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
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]);