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 |
|---|---|---|---|---|---|---|---|---|---|
| 1159 | 1159 | 1898-11-16 | 3 | a-b | Proposal written by Hong Ruchong to move capital of China. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
| 1160 | 1160 | 1898-11-16 | 3 | b-c | Four Chinese men in Gilgandra, New South Wales, arrested for gambling. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
| 1161 | 1161 | 1898-11-16 | 3 | c | Bridegroom in Gaoyao robbed. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
| 1162 | 1162 | 1898-11-16 | 3 | c-d | Man in Dongguan kills himself after stabbing dog to death. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
| 1163 | 1163 | 1898-11-16 | 3 | d | Chinese fellow in Goulburn, NSW, burned to death. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
| 1164 | 1164 | 1898-11-16 | 3 | d | Diamonds from mountain in Shandong province is famous. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
| 1165 | 1165 | 1898-11-16 | 3 | d-e | Fireworks kill five people in Shunde, Guangdong province. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
| 1166 | 1166 | 1898-11-16 | 3 | e | Statistics from census in Wuchang, Hubei province. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
| 1167 | 1167 | 1898-11-16 | 3 | e-f | Chinese gardener stabbed to death in garden in Wagga Wagga, New South Wales. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
| 1168 | 1168 | 1898-11-16 | 3 | f | Yellow River burst its banks, flooding large area; twenty American soldiers arrive in Beijing to protect diplomats. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
| 1169 | 1169 | 1898-11-16 | 3-2 | f-a-b | Current political situation and developments in China. | http://trove.nla.gov.au/newspaper/page/24102200 | 24102200 | ||
| 1170 | 1170 | 1898-11-16 | 2 | b | Two boys in Moorabin, Melbourne, found not guilty of seriously injurying father. | http://trove.nla.gov.au/newspaper/page/24102199 | 24102199 | ||
| 1171 | 1171 | 1898-11-16 | 2 | b-c | Trouble in brothel in Panyu. | http://trove.nla.gov.au/newspaper/page/24102199 | 24102199 | ||
| 1172 | 1172 | 1898-11-16 | 2 | c | Two Chinese robbed on the way from Melbourne to Sydney. | http://trove.nla.gov.au/newspaper/page/24102199 | 24102199 | ||
| 1173 | 1173 | 1898-11-16 | 2 | c-d | Reminder to Chinese that great care needs to be taken in transporting gold. | http://trove.nla.gov.au/newspaper/page/24102199 | 24102199 | ||
| 1174 | 1174 | 1898-11-16 | 2 | d | Girl punished for theft; man sentenced for pick-pcoketing; two men fined for breeding dogs without correct licence. | http://trove.nla.gov.au/newspaper/page/24102199 | 24102199 | ||
| 1175 | 1175 | 1898-11-16 | 2 | e | Brother in New Castle arrested for bullying his sister. | http://trove.nla.gov.au/newspaper/page/24102199 | 24102199 | ||
| 1176 | 1176 | 1898-11-16 | 2 | e | Man in Albury dies when his canoe capsizes in river. | http://trove.nla.gov.au/newspaper/page/24102199 | 24102199 | ||
| 1177 | 1177 | 1898-11-16 | 2 | e-f | Famous lawyer in NSW dies in traffic accident. | http://trove.nla.gov.au/newspaper/page/24102199 | 24102199 | ||
| 1178 | 1178 | 1898-11-16 | 2 | f | Guangzhou streets are to be cleaned. | http://trove.nla.gov.au/newspaper/page/24102199 | 24102199 | ||
| 1179 | 1179 | 1898-11-16 | 4 | a | Melbourne woman dies, crushed under train in accident. | http://trove.nla.gov.au/newspaper/page/24102197 | 24102197 | ||
| 1180 | 1180 | 1898-11-16 | 4 | a | Chinese robbed on Gibbs Street in Sydney. | http://trove.nla.gov.au/newspaper/page/24102197 | 24102197 | ||
| 1181 | 1181 | 1898-11-16 | 4 | b | British ambassador inspects railway near Beijing; Britain, Japan and USA work together to maintain stability in China; Chinese ambassador to Britain says China should learn from Britain. | http://trove.nla.gov.au/newspaper/page/24102197 | 24102197 | ||
| 1182 | 1182 | 1898-11-16 | 4 | b | Timetable to Asian ports. | http://trove.nla.gov.au/newspaper/page/24102197 | 24102197 | ||
| 1183 | 1183 | 1898-11-16 | 4 | c | Price list of prodcuts in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102197 | 24102197 | ||
| 1184 | 1184 | 1898-11-16 | 4 | c | Price list of products in Melbourne market. | http://trove.nla.gov.au/newspaper/page/24102197 | 24102197 |
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]);