This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 2718 | 2718 | 1899-06-10 | 3 | a | Tax income and expenditure in Queensland. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2719 | 2719 | 1899-06-10 | 3 | a | Egyptian government prepares for the spread of disease. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2720 | 2720 | 1899-06-10 | 3 | a | Quantity of gold exported from Australian colonies. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2721 | 2721 | 1899-06-10 | 3 | a | Five Chinese baptised in Albury, Wu Yaoli, Lei Qi and three others. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2722 | 2722 | 1899-06-10 | 3 | b | A charity institution in Jiangxi province. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2723 | 2723 | 1899-06-10 | 3 | b | China is to purchase gunboats from Germany. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2724 | 2724 | 1899-06-10 | 3 | b | Germans provoke trouble in Shandong province. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2725 | 2725 | 1899-06-10 | 3 | b | His Majesty inquired about establishment of a munitions factory in Wuchang, Hubei province. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2726 | 2726 | 1899-06-10 | 3 | c | A farmer in Adelaide died suddenly. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2727 | 2727 | 1899-06-10 | 3 | c | America is to increase the number of recruits in its army. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2728 | 2728 | 1899-06-10 | 3 | c | Japan tries to become a strong eastern country. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2729 | 2729 | 1899-06-10 | 3 | c | Workers strike for better pay and conditions in Russia. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2730 | 2730 | 1899-06-10 | 3 | c | French in Madagascar. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2731 | 2731 | 1899-06-10 | 3 | c | An aged man in mad house in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2732 | 2732 | 1899-06-10 | 3 | c-d | German troops in Shandong; response of Chinese government. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2733 | 2733 | 1899-06-10 | 3 | d | A coal ship from New Castle to Sydney was in trouble while in the sea. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2734 | 2734 | 1899-06-10 | 3 | d | New Zealand has new postage requirements. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2735 | 2735 | 1899-06-10 | 3 | d | Workers in France are on strike for more pay. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2736 | 2736 | 1899-06-10 | 3 | d | Income tax in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2737 | 2737 | 1899-06-10 | 3 | d | Russia demands more from Chinese government. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2738 | 2738 | 1899-06-10 | 3 | d-e | A man in Nanhai county was burgled while he entertained his friends. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2739 | 2739 | 1899-06-10 | 3 | e | China sends a consul, Mr Li, to Luzon. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2740 | 2740 | 1899-06-10 | 3 | e | Big bones found in America, yet to be identified. | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 | ||
| 2741 | 2741 | 1899-06-10 | 3 | e-f | The assault of a missionary in Shenyang is under investigation | http://trove.nla.gov.au/newspaper/page/24102427 | 24102427 |
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]);