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 |
|---|---|---|---|---|---|---|---|---|---|
| 676 | 676 | 1898-09-03 | 4 | a-b | Sydney man pays compensation for failing to keep engagement with woman. | http://trove.nla.gov.au/newspaper/page/24102117 | 24102117 | ||
| 677 | 677 | 1898-09-03 | 4 | b | White man accuses Chinese man of theft. | http://trove.nla.gov.au/newspaper/page/24102117 | 24102117 | ||
| 678 | 678 | 1898-09-03 | 4 | b-c | People complain that carriages used to transport vegetable are not clean. | http://trove.nla.gov.au/newspaper/page/24102117 | 24102117 | ||
| 679 | 679 | 1898-09-03 | 4 | c | Liner timetables for Asian ports. | http://trove.nla.gov.au/newspaper/page/24102117 | 24102117 | ||
| 680 | 680 | 1898-09-03 | 4 | c | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102117 | 24102117 | ||
| 681 | 681 | 1898-09-03 | 3 | a-b-c | Second instalment of proposal to set up Quit-opium-smoking Association in Australia. Written by Liu Yuanchun. | http://trove.nla.gov.au/newspaper/page/24102120 | 24102120 | ||
| 682 | 682 | 1898-09-03 | 3 | c | Robbery case in Xiangshan, Guangdong. | http://trove.nla.gov.au/newspaper/page/24102120 | 24102120 | ||
| 683 | 683 | 1898-09-03 | 3 | c-d | Bandits arrested for people smuggling in western Guangdong. | http://trove.nla.gov.au/newspaper/page/24102120 | 24102120 | ||
| 684 | 684 | 1898-09-03 | 3 | d | Japanese girls travel overseas as prostitutes. Figures on rate of prostitution amongst Japanese women around world. | http://trove.nla.gov.au/newspaper/page/24102120 | 24102120 | ||
| 685 | 685 | 1898-09-03 | 3 | d-e | Brothel dispute in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102120 | 24102120 | ||
| 686 | 686 | 1898-09-03 | 3 | e | Scholar in Xiangshan kills neighbour to obtain books. | http://trove.nla.gov.au/newspaper/page/24102120 | 24102120 | ||
| 687 | 687 | 1898-09-03 | 3 | e-f | French soldiers clash with civilians in Ningbo, Zhejiang province, over land use. Twenty-two Chinese killed, more than fifty injured. | http://trove.nla.gov.au/newspaper/page/24102120 | 24102120 | ||
| 688 | 688 | 1898-09-03 | 3 | f | Heavy brothers in Sweden. | http://trove.nla.gov.au/newspaper/page/24102120 | 24102120 | ||
| 689 | 689 | 1898-09-03 | 3-2 | f-a | Advantages of reforming the Examination. | http://trove.nla.gov.au/newspaper/page/24102120 | 24102120 | ||
| 690 | 690 | 1898-09-03 | 2 | a | Name list of people who successfully passed highest Imperial Examination this year. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 | ||
| 691 | 691 | 1898-09-03 | 2 | a-b | Magistrate in Nanhai county stopped on way to work by women protesting against injustices. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 | ||
| 692 | 692 | 1898-09-03 | 2 | b | Brides swapped in Xiangshan. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 | ||
| 693 | 693 | 1898-09-03 | 2 | b-c | Military general in Luzon dresses like woman. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 | ||
| 694 | 694 | 1898-09-03 | 2 | c | Governor of Macao seeks permission of Chinese government to grant Macao ships entry to China's ports. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 | ||
| 695 | 695 | 1898-09-03 | 2 | c | Man in Guangzhou recieves treasure. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 | ||
| 696 | 696 | 1898-09-03 | 2 | c-d | Kind salesman, Mr Thomson, treats all customers equally and is very kind to Chinese. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 | ||
| 697 | 697 | 1898-09-03 | 2 | d | Population statistics from New Zealand and Victoria. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 | ||
| 698 | 698 | 1898-09-03 | 2 | d-e | White man kills friend. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 | ||
| 699 | 699 | 1898-09-03 | 2 | e | British council of business sends representative to investigation business in China. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 | ||
| 700 | 700 | 1898-09-03 | 2 | e-f | Marriage, woman, man in Panyu returns his bride immediately. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 | ||
| 701 | 701 | 1898-09-03 | 2 | f | Many die in disease outbreak in India. | http://trove.nla.gov.au/newspaper/page/24102119 | 24102119 |
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]);