This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 2544 | 2544 | 1899-05-24 | 3 | a | Ambulance service begins in Sydney. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2545 | 2545 | 1899-05-24 | 3 | a | Gold miners strike in Belgium; New Zealanders protest the employment of a Chinese; Australian colonies will soon join in federation; Chinese hope to be treated equally in new federation; French officer shots African women. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2546 | 2546 | 1899-05-24 | 3 | a | Russia demands the Chinese government allow it to build railway from Beijing to the Northeastern China. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2547 | 2547 | 1899-05-24 | 3 | a | Britain publishes a book on China. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2548 | 2548 | 1899-05-24 | 3 | b | On the international peace conference to be held in St Petersburg. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2549 | 2549 | 1899-05-24 | 3 | b | The war over steel prices in Britain and the USA; copper prices in London; bicycle company in America; Britain and France negotiate over their interest in Africa. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2550 | 2550 | 1899-05-24 | 3 | b | Loans taken out in the building of the railway from Beijing to northeastern China. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2551 | 2551 | 1899-05-24 | 3 | b | The Prince will inspect a military parade in London. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2552 | 2552 | 1899-05-24 | 3 | b-c | A thief and a robber in Sydney. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2553 | 2553 | 1899-05-24 | 3 | c | New York is ready to welcome the return of its commander from the Philippines. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2554 | 2554 | 1899-05-24 | 3 | c | A woman in Sydney is penalised for selling beer without a licence. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2555 | 2555 | 1899-05-24 | 3 | c | Readers in Britain refuse to publish a newspaper on Sundays. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2556 | 2556 | 1899-05-24 | 3 | c | Pope declares there would be only nineteen weeks in 1900. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2557 | 2557 | 1899-05-24 | 3 | c-d | British Prime Minister concerns himself with British citizens in dispute with Denmark and Iceland. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2558 | 2558 | 1899-05-24 | 3 | d | Epidemic disease in India. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2559 | 2559 | 1899-05-24 | 3 | d | Yellow River breaks its banks in Henan province. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2560 | 2560 | 1899-05-24 | 3 | d | Chinese resistance against British occupation. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2561 | 2561 | 1899-05-24 | 3 | d | British in Transvaal, South Africa and treatment to them. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2562 | 2562 | 1899-05-24 | 3 | d-e | Astrologists develop new methods to study the universe. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2563 | 2563 | 1899-05-24 | 3 | e | Iron snake found in Panyu mountain. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2564 | 2564 | 1899-05-24 | 3 | f | Hail storm in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2565 | 2565 | 1899-05-24 | 3 | f | New uses for Chemistry. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2566 | 2566 | 1899-05-24 | 3 | f | Yuan Shikai escapes narrowly from an assassination in Tianjin. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
| 2567 | 2567 | 1899-05-24 | 3 | f | Some Chinese troops were moved from Tianjin to Beijing. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 |
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]);