This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 797 | 797 | 1898-09-24 | 4 | a | Nuns in Guangzhou removed from temples. The temples will soon be turned into schools. | http://trove.nla.gov.au/newspaper/page/24102137 | 24102137 | ||
| 798 | 798 | 1898-09-24 | 4 | a-b | Court case, Sydney man sues newspaper editor for defamation. | http://trove.nla.gov.au/newspaper/page/24102137 | 24102137 | ||
| 799 | 799 | 1898-09-24 | 4 | b | Prince of Italy says goodbye to King of Austria. | http://trove.nla.gov.au/newspaper/page/24102137 | 24102137 | ||
| 800 | 800 | 1898-09-24 | 4 | b | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102137 | 24102137 | ||
| 801 | 801 | 1898-09-24 | 3 | a-b-c | First part of the memorial report presented by Xu Zhijing to His Majesty on the reform of Imperial Examination. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
| 802 | 802 | 1898-09-24 | 3 | c | Juvenile crime, Sydney woman robbed by group of children. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
| 803 | 803 | 1898-09-24 | 3 | c-d | 12-year-old mother in Zhaoqing, Guangdong. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
| 804 | 804 | 1898-09-24 | 3 | d | Tornado causes flooding in India. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
| 805 | 805 | 1898-09-24 | 3 | d-e | Two men from London travel by hot-air balloon. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
| 806 | 806 | 1898-09-24 | 3 | e | Girl in Guangzhou works hard as man in order to make more money. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
| 807 | 807 | 1898-09-24 | 3 | e-f | Rulers compete for power in same area. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
| 808 | 808 | 1898-09-24 | 3 | f | Man in Sydney dies in bicycle race. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
| 809 | 809 | 1898-09-24 | 3-2 | f-a | Melbourne woman hangs herself because she has nothing to eat; another woman suicides because she cannot feed her six children. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
| 810 | 810 | 1898-09-24 | 2 | a-b-c | Migration patterns of Chinese into Australian colonies, governments propose new immigration regulations to stop entry of Chinese, blacks and other Asians. | http://trove.nla.gov.au/newspaper/page/24102139 | 24102139 | ||
| 811 | 811 | 1898-09-24 | 2 | c | Several American and French churches near Chongqing in Sichuan province burnt down by local residents. | http://trove.nla.gov.au/newspaper/page/24102139 | 24102139 | ||
| 812 | 812 | 1898-09-24 | 2 | c | Strange omen as black rain falls in Ireland. | http://trove.nla.gov.au/newspaper/page/24102139 | 24102139 | ||
| 813 | 813 | 1898-09-24 | 2 | c-d | Man in Guangzhou shows gratitude to wife. | http://trove.nla.gov.au/newspaper/page/24102139 | 24102139 | ||
| 814 | 814 | 1898-09-24 | 2 | d-e | Three Chinese men in Queensland catch crocodile while fishing. | http://trove.nla.gov.au/newspaper/page/24102139 | 24102139 | ||
| 815 | 815 | 1898-09-24 | 2 | e | Sydney carriage driver recovers after injury from accident . | http://trove.nla.gov.au/newspaper/page/24102139 | 24102139 | ||
| 816 | 816 | 1898-09-24 | 2 | e-f | Three men penalised for horse abuse; man fined for travelling from New Castle to Sydney without ticket; young man sentenced for pick-pocketing. | http://trove.nla.gov.au/newspaper/page/24102139 | 24102139 | ||
| 817 | 817 | 1898-09-24 | 2 | f | British newspapers welcome efforts to reform Imperial examinations and to set up new schools; Russia, France and Britain disagree on railway building in China; Britain's new plan for Tianjin railway. | http://trove.nla.gov.au/newspaper/page/24102139 | 24102139 | ||
| 818 | 818 | 1898-09-24 | 2 | f | Housemaid in Guangzhou steals goods from the house where she works. | http://trove.nla.gov.au/newspaper/page/24102139 | 24102139 |
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]);