This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6472 | 6472 | 1900-11-21 | 2 | e | Russian orders other foreign troops to leave the railway from Tanggu to Beijing; China will agree to most requirements imposed by foreign governments; USA wants to punish troublemakers and demands compensation from Chinese government; a group of Russian soldiers were besieged by Chinese troops in the north of Shanhaiguan; Russia source says German and French soldiers are robbers. | Other... | http://trove.nla.gov.au/newspaper/page/24103021 | 24103021 | |
6473 | 6473 | 1900-11-21 | 2 | e | New Governor General for the six Australian colonies, Lord Hopetoun, is on his way to Australia. The six colonies which will soon for a commonwealth are New South Wales, Victoria, Queensland, South Australia, Western Australia, and Tasmania. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103021 | 24103021 | |
6474 | 6474 | 1900-11-21 | 2 | e | Royal guards from Britain are on their way to Australia for the ceremony of Commonwealth. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103021 | 24103021 |
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]);