This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 2956 | 2956 | 1899-07-05 | 2 | a | Imperial edicts on local affairs in Jiangxi, Hubei, Guangxi and Yunnan. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2957 | 2957 | 1899-07-05 | 2 | a-b | Imperial edicts. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2958 | 2958 | 1899-07-05 | 2 | b-c | A report submitted by Tan Zhonglin, Governor of Guangdong and Guangxi. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2959 | 2959 | 1899-07-05 | 2 | c | Another report submitted by Tan Zhonglin, Governor of Guangdong and Guangxi. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2960 | 2960 | 1899-07-05 | 2 | c-e | An essay written by Shoushan Jushi on the cultivation of moral character. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2961 | 2961 | 1899-07-05 | 2 | e | Gold miners in Yunnan cause social chaos. French consulate office harassed over behaviour of French in Yunnan. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2962 | 2962 | 1899-07-05 | 2 | e | The Philippines increased its tax rates after the war with America. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2963 | 2963 | 1899-07-05 | 2 | e | Riots and demonstrations in Brussels. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2964 | 2964 | 1899-07-05 | 2 | e | A liner of Gibbs Bright & Co. stranded near Adelaide. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2965 | 2965 | 1899-07-05 | 2 | e-f | Zhaoqing organises a ceremony to greet God and to exorcise demons. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2966 | 2966 | 1899-07-05 | 2 | f | Young men in Goulburn register their names for a possible journey to Transvaal. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2967 | 2967 | 1899-07-05 | 2 | f | Two traffic accidents in Sydney. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2968 | 2968 | 1899-07-05 | 2 | f | Soldiers from the USA infected with diseases while in the Philippines. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2969 | 2969 | 1899-07-05 | 2 | f | A man in London purchases a horse at a very high price. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 | ||
| 2970 | 2970 | 1899-07-05 | 2 | f | British Prime Minister wants to fight Transvaal. | http://trove.nla.gov.au/newspaper/page/24102456 | 24102456 |
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]);