This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 4576 | 4576 | 1900-02-17 | 3 | a-b | Chinese ambassador to Britain, Luo Fenglu, delivers a speech at a London dinner party on British business activities in China, Sino-Britain relations, and others issues. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102700 | 24102700 | |
| 4577 | 4577 | 1900-02-17 | 2 | b-c | An essay, written by anonymous author, advocates that Empress Dowager should return the court power to the Emperor. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4578 | 4578 | 1900-02-17 | 2 | c-d | Reports on the war between Britain and Transvaal in south Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4579 | 4579 | 1900-02-17 | 2 | d | Winning list of Tattslotto in Western Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4580 | 4580 | 1900-02-17 | 2 | d | The imports and exports of New Zealand, its business relations with Britain. Imports and exports of Britain. | Other... | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4581 | 4581 | 1900-02-17 | 2 | d | A boy in Killcare Heights, Sydney, was murdered and royal police are looking for the murderer. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4582 | 4582 | 1900-02-17 | 2 | e | A girl in Wellington was killed while waiting for a train. | Other... | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4583 | 4583 | 1900-02-17 | 2 | e | A yacht was swallowed by waves on a Sydney beach. | Other... | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4584 | 4584 | 1900-02-17 | 2 | e | Passengers from Guangzhou to Nanhai were robbed while travelling. | China | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4585 | 4585 | 1900-02-17 | 2 | e | Bandits in Dong'an and Luoding counties. | China | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4586 | 4586 | 1900-02-17 | 2 | e | Wine production in Australia; a boy in Victoria was penalised for sabotage; a postman was shot. | Australia | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4587 | 4587 | 1900-02-17 | 2 | f | A British newspaper comments on the efforts of Western countries to carve up China. | Britain | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4588 | 4588 | 1900-02-17 | 2 | f | A man and his uncle married a couple of sisters in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24102701 | 24102701 | |
| 4589 | 4589 | 1900-02-17 | 3 | a | The progress of a railway project in northeastern China. | China | http://trove.nla.gov.au/newspaper/page/24102700 | 24102700 | |
| 4590 | 4590 | 1900-02-17 | 3 | a-c | More reports on the war between Britain and Transvaal in south Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24102700 | 24102700 |
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]);