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 |
|---|---|---|---|---|---|---|---|---|---|
| 3812 | 3812 | 1899-10-14 | 2 | a-c | A report from Gang Yi on his inspection of tax collection in south China. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3813 | 3813 | 1899-10-14 | 2 | c | A greedy woman in Castlemain, Victoria, died. Nobody noticed for a few days. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3814 | 3814 | 1899-10-14 | 2 | c-d | A priest in Warrnambool, Victoria, was ordered to pay his maidservant. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3815 | 3815 | 1899-10-14 | 2 | d | The son of the post office director dies in an accident; beef factory closed for two months; Adelaide liner robbed. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3816 | 3816 | 1899-10-14 | 2 | d | A man in Toowoomba kills a girl by accident, was released free of charge. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3817 | 3817 | 1899-10-14 | 2 | d | Reports on gold discovery in Cooktown. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3818 | 3818 | 1899-10-14 | 2 | d | Cold weather in Queensland damaged some crops. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3819 | 3819 | 1899-10-14 | 2 | d | Reward for the capture of a criminal who murdered a man in Winton, Queensland. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3820 | 3820 | 1899-10-14 | 2 | e | Britain is to declare war; number of British soldiers sent to Transvaal; German's response to British plan; Transvaal forces British citizens to leave; American president proposes mediation. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3821 | 3821 | 1899-10-14 | 2 | e | A big fire in country NSW town destroys 15 shops. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3822 | 3822 | 1899-10-14 | 2 | e-f | Income tax revenue from New South Wales, Victoria, and New Zealand. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3823 | 3823 | 1899-10-14 | 2 | f | Cold weather and frost in Queensland. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3824 | 3824 | 1899-10-14 | 2 | f | Dead body found in Brisbane house. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3825 | 3825 | 1899-10-14 | 2 | f | A priest's house was burgled while he was praying in church. | http://trove.nla.gov.au/newspaper/page/24102566 | 24102566 | ||
| 3826 | 3826 | 1899-10-14 | 3 | a | A group of robbers on the Yangtse River near Wuhu, Anhui province. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3827 | 3827 | 1899-10-14 | 3 | b | Liu Kunyi, Governor of Jiangsu and Zhejiang, is to retire; Rong Lu will replace Liu Kunyi; Li Hongzhang to be Governor of Hebei Province, and other replacements announced. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3828 | 3828 | 1899-10-14 | 3 | b-c | Tram on George St, Sydney, has a test run. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3829 | 3829 | 1899-10-14 | 3 | c | A charitiable institution has been established in Zengcheng. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3830 | 3830 | 1899-10-14 | 3 | c | Many foxes found and hunted in Warrnambool, Victoria. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3831 | 3831 | 1899-10-14 | 3 | c | A man in Ballarat dies on the street. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3832 | 3832 | 1899-10-14 | 3 | c | Melbourne experiences cold weather in September. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3833 | 3833 | 1899-10-14 | 3 | c | Adelaide experiences cold weather. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3834 | 3834 | 1899-10-14 | 3 | d | Chinese, Ya Ke, in Ararat commits suicide in a log house. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3835 | 3835 | 1899-10-14 | 3 | d | Goulburn experiences cold weather. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3836 | 3836 | 1899-10-14 | 3 | d | Mr Xiao Dexing and Mr Lei Rui, two executives of Wing Sang & Co. of Campbell Street, Sydney, were robbed on the street. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3837 | 3837 | 1899-10-14 | 3 | d | Sudden hot wind warms Sydney. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3838 | 3838 | 1899-10-14 | 3 | d | Spanish government imposes higher tax on fans imported from Japan. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3839 | 3839 | 1899-10-14 | 3 | e | Frost in Britain damages fruits; cold weather and frost in Queensland damages crops and fruits. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3840 | 3840 | 1899-10-14 | 3 | e | Meteorite shower witnessed in Sydney. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3841 | 3841 | 1899-10-14 | 3 | e | A man in the USA makes bulletproof clothing from iron. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3842 | 3842 | 1899-10-14 | 3 | e | US man makes a balloon that can be used to save lives. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3843 | 3843 | 1899-10-14 | 3 | f | A boat was stranded near Sydney. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3844 | 3844 | 1899-10-14 | 3 | f | A bank in New Zealand was burgled. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3845 | 3845 | 1899-10-14 | 3 | f | Timetable of liners to Asian ports. | http://trove.nla.gov.au/newspaper/page/24102565 | 24102565 | ||
| 3846 | 3846 | 1899-10-14 | 4 | a | New magistrate of Lianxian county develops new work style, encourages new mood in society. | http://trove.nla.gov.au/newspaper/page/24102568 | 24102568 |
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]);