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 |
|---|---|---|---|---|---|---|---|---|---|
| 3030 | 3030 | 1899-07-12 | 2 | a-c | The first part of a report submitted by Pu Liang. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
| 3031 | 3031 | 1899-07-12 | 2 | c-d | An essay on the restructuring and reorganisation of China's bureaucracy. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
| 3032 | 3032 | 1899-07-12 | 2 | d-e | Storm in London; chaos in the Parliament of Italy; a baby boy was abandoned in Albury; fight between Aboriginal groups in Queensland; metal exports from Tasmania; cold weather influences agricultural production in Australia. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
| 3033 | 3033 | 1899-07-12 | 2 | e | A worker dies in an accident at a sawmill in Sydney. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
| 3034 | 3034 | 1899-07-12 | 2 | e | Hobart, Tasmania passes law prohibiting anyone under the age of 13 from smoking on the street. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
| 3035 | 3035 | 1899-07-12 | 2 | e | Epidemic in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
| 3036 | 3036 | 1899-07-12 | 2 | f | A man in Nanhai sold his hard-working cattle to butcher immediately after it ceased being able to work. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
| 3037 | 3037 | 1899-07-12 | 2 | f | The habit of drinking in New Zealand. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
| 3038 | 3038 | 1899-07-12 | 2 | f | A man in Melbourne penalised for stealing bank notes from post office. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
| 3039 | 3039 | 1899-07-12 | 2 | f | France's budget for its army. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
| 3040 | 3040 | 1899-07-12 | 2 | f | Rev. Zhou in Qingpu county, Zhejiang province, is building an astronomical observatory in a nearby mountain. | http://trove.nla.gov.au/newspaper/page/24102464 | 24102464 | ||
| 3041 | 3041 | 1899-07-12 | 3 | a | Wool production in various towns of New South Wales. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3042 | 3042 | 1899-07-12 | 3 | a | Some US soldiers in Luzon were hospitalised. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3043 | 3043 | 1899-07-12 | 3 | a-b | An essay, written by Congshan jushi, comments on the education and development of the next generation. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3044 | 3044 | 1899-07-12 | 3 | b | Chinese shepherd in Moore, NSW, Rong Fuhua, committed suicide. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3045 | 3045 | 1899-07-12 | 3 | b | A Russian newspaper comments on Russia's relation with China and other Western countries. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3046 | 3046 | 1899-07-12 | 3 | b-c | Residents in the Philippines clash with USA forces; Transvaal prepares to fight the British; European scientists wrote to the Tsar of Russia on Finland; King of Sudan; Samoa news; a woman in Bendigo dies in a clinic; a Chinese shop in Bendigo was burgled; tin price in London; sugar export from Queensland to New Zealand; weather in Queensland; bank news in New Zealand. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3047 | 3047 | 1899-07-12 | 3 | c | Japan returns gunboats robbed from China. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3048 | 3048 | 1899-07-12 | 3 | c | Huang Huaisen, Governor of Guangxi, encourages China to learn from Western knowledge. traditions and practices. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3049 | 3049 | 1899-07-12 | 3 | c | Volunteer doctors help to treat the epidemic in Nanhai county. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3050 | 3050 | 1899-07-12 | 3 | d | Gaoyao county in the east of Guangdong tries to wipe out bandits. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3051 | 3051 | 1899-07-12 | 3 | d | Administrative divisions of Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3052 | 3052 | 1899-07-12 | 3 | d | Governor of Jiangsu and Zhejiang has been impeached. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3053 | 3053 | 1899-07-12 | 3 | d | Empress Dowager orders Li Hongzhang to promote business of tea and silk. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3054 | 3054 | 1899-07-12 | 3 | d | Two butchers in Panyu recieve the punishment they deserve. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3055 | 3055 | 1899-07-12 | 3 | e | Australia's business dealings with China. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3056 | 3056 | 1899-07-12 | 3 | e | An old woman in Western Australia dies in a train accident. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3057 | 3057 | 1899-07-12 | 3 | e | Spain joins in other countries in asking for a settlement from China. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3058 | 3058 | 1899-07-12 | 3 | e | Russian soldiers act violently in northeastern China. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3059 | 3059 | 1899-07-12 | 3 | e | Ginseng production in Jilin province. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3060 | 3060 | 1899-07-12 | 3 | f | Women must withdraw from a temple ceremony in Panyu, at which only men are allowed to attend. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3061 | 3061 | 1899-07-12 | 3 | f | Commander Nie Gongting trains his army successfully. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3062 | 3062 | 1899-07-12 | 3 | f | Guangxi will have new officials soon. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3063 | 3063 | 1899-07-12 | 3 | f | Russian starts business zones in Hankou. | http://trove.nla.gov.au/newspaper/page/24102463 | 24102463 | ||
| 3064 | 3064 | 1899-07-12 | 4 | a | News from Xiangshan county, e.g., grain price, weather, charity institutions, etc. | http://trove.nla.gov.au/newspaper/page/24102466 | 24102466 | ||
| 3065 | 3065 | 1899-07-12 | 4 | a | Gold price in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102466 | 24102466 | ||
| 3066 | 3066 | 1899-07-12 | 4 | a | Two Chinese return home with gold. | http://trove.nla.gov.au/newspaper/page/24102466 | 24102466 |
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]);