This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 3614 | 3614 | 1899-09-20 | 2 | a-b | A report from Tan Zhonglin, Governor of Guangdong and Guangxi. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3615 | 3615 | 1899-09-20 | 2 | b | A report from En'ze on the purchase and transportation of weapons from Germany. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3616 | 3616 | 1899-09-20 | 2 | b-d | A letter from Yang Quyun and Chinese community in Yokohama, Japan, reporting on Liang Qichao's activities there. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3617 | 3617 | 1899-09-20 | 2 | d-e | British military commanders discuss the situation in Transvaal; comments from various countries on Britain's plan of attack against Transvaal; soldiers from India leave for south Africa; Transvaal seems ready to fight Britain; support of British people for the fighting; number of soldiers from India. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3618 | 3618 | 1899-09-20 | 2 | e | A man in Morang, NSW, died in a hunting accident. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3619 | 3619 | 1899-09-20 | 2 | e | A female criminal and her lawyer were both sentenced in Auckland, New Zealand. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3620 | 3620 | 1899-09-20 | 2 | e | A Chinese in New Castle was penalised for gambling illegally. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3621 | 3621 | 1899-09-20 | 2 | e | Changes in the New South Wales Parliament. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3622 | 3622 | 1899-09-20 | 2 | e | Chinese immigrants in Brisbane are allowed to gamble. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3623 | 3623 | 1899-09-20 | 2 | e-f | Hunting harvest in Glen Innes, NSW. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3624 | 3624 | 1899-09-20 | 2 | f | Brisbane is crowded as missionaries gather. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3625 | 3625 | 1899-09-20 | 2 | f | A doorkeeper of a graveyard in Britain was penalised for negligence. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3626 | 3626 | 1899-09-20 | 2 | f | Fire in a Sydney theatre. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3627 | 3627 | 1899-09-20 | 2 | f | Queensland holds a federation referendum; majority support the federation proposal. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3628 | 3628 | 1899-09-20 | 2 | f | Telegram offices in China charge half price for sending news to newspapers. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 |
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]);