This data as json, CSV (advanced)
Suggested facets: column
date (date) 1 ✖
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 3935 | 3935 | 1899-10-28 | 3 | a | Beijing has more power struggle; Han soldiers were treated badly in the army; building of an iron house nearly completed for the future house arrest of high-level officials; the Emperor is recovering steadily. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3936 | 3936 | 1899-10-28 | 3 | b | Russia wants to take over Persian Bay, across to India. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3937 | 3937 | 1899-10-28 | 3 | b | Russians in Korea are under the control of Japanese. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3938 | 3938 | 1899-10-28 | 3 | b-c | British official, after visiting Japan and Beijing, comments on Britain's diplomatic relations with Japan and China. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3939 | 3939 | 1899-10-28 | 3 | b | The reform party has split into two groups, Kang Youwei and Sun Yatsen. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3940 | 3940 | 1899-10-28 | 3 | c-d | Fighting between British soldiers and Transvaal troops at different places; fighting between the Dutch and British soldiers; detailed report on the progress of the war. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3941 | 3941 | 1899-10-28 | 3 | d | New South Wales requires license to breed dogs. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3942 | 3942 | 1899-10-28 | 3 | e | Six passengers were found with smallpox when a liner arrived in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3943 | 3943 | 1899-10-28 | 3 | e | An old woman in New South Wales died in a house fire. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3944 | 3944 | 1899-10-28 | 3 | e | Tasmania organises a fair for farm products. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3945 | 3945 | 1899-10-28 | 3 | e | A man in Western Australia died in the gold lake. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3946 | 3946 | 1899-10-28 | 3 | e | A man from Sydney won a swimming championship in London. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3947 | 3947 | 1899-10-28 | 3 | e | Twenty Chinese arrested for gambling at La Trobe St, Melbourne. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3948 | 3948 | 1899-10-28 | 3 | f | Germany has just built a new gunboat. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3949 | 3949 | 1899-10-28 | 3 | f | Chancellor of Newtown in Sydney is keen to help Britain in the Boer War. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 | ||
| 3950 | 3950 | 1899-10-28 | 3 | f | A man in Melbourne was charged with murdering his wife. | http://trove.nla.gov.au/newspaper/page/24102582 | 24102582 |
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]);