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 |
|---|---|---|---|---|---|---|---|---|---|
| 1185 | 1185 | 1898-11-19 | 3 | a-b | Memorial report, written by Lin Luocun and presented to His Majesty, suggests to use syncopated words. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
| 1186 | 1186 | 1898-11-19 | 3 | b-c | New Castle boy kicked to death by horse. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
| 1187 | 1187 | 1898-11-19 | 3 | c | Juvenile crime, two naughty boys in Melbourne kill man. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
| 1188 | 1188 | 1898-11-19 | 3 | c-d | Fireworks in Zhaoqing, Guangdong province, nearly caused big fire. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
| 1189 | 1189 | 1898-11-19 | 3 | d | Shark found dead near New Castle. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
| 1190 | 1190 | 1898-11-19 | 3 | e | Governor in Guangdong extended favour to gangsters. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
| 1191 | 1191 | 1898-11-19 | 3 | d-e | Tottoos in USA. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
| 1192 | 1192 | 1898-11-19 | 3 | e | Western medicine's new discoveries about nature of human brain. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
| 1193 | 1193 | 1898-11-19 | 3 | e-f | Only forty of the 250 personnel will retain their positions after changes to the Imperial Academy (han lin yuan). | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
| 1194 | 1194 | 1898-11-19 | 3 | f | Japanese government attempts to increase loans from foreign nations. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
| 1195 | 1195 | 1898-11-19 | 3 | f | Li Hongzhang ordered to dredge and realign the Yellow River in order to prevent flooding. | http://trove.nla.gov.au/newspaper/page/24102204 | 24102204 | ||
| 1196 | 1196 | 1898-11-19 | 2 | a | Deniliquin in New South Wales affected by plague of locusts. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1197 | 1197 | 1898-11-19 | 2 | a | Earthquakes occur in Japan and four areas in New South Wales at the same time. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1198 | 1198 | 1898-11-19 | 2 | a-b | Chinese in Waterloo, Sydney detained for theft. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1199 | 1199 | 1898-11-19 | 2 | b | Leather factory in Geelong, Victoria, burnt to ashes in fire. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1200 | 1200 | 1898-11-19 | 2 | b-c | Two visitors from Korea arrive in Hankou. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1201 | 1201 | 1898-11-19 | 2 | c | White man fined for kicking Chinese man. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1202 | 1202 | 1898-11-19 | 2 | c | Meteor spotted in northeast sky in Guangzhou on day of Mid-Autumn Festival. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1203 | 1203 | 1898-11-19 | 2 | c-d | A man in Guangzhou who was wrongly sentenced to death now haunts province demanding a life. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1204 | 1204 | 1898-11-19 | 2 | d | Brothel in Dongguan in trouble with law. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1205 | 1205 | 1898-11-19 | 2 | d-e | Report on Empress' attempts to control newspapers and response from press. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1206 | 1206 | 1898-11-19 | 2 | e | One of Kang Youwei's former schools closes down. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1207 | 1207 | 1898-11-19 | 2 | e | Bandit in Zengcheng hides in vat in order to steal goods. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1208 | 1208 | 1898-11-19 | 2 | f | Former Minister of the Board of Rites, Xu Yingkui, was reappointed shortly after his dismissal. The news came by telephone. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1209 | 1209 | 1898-11-19 | 2 | f | Three men arrested for gun smuggling. | http://trove.nla.gov.au/newspaper/page/24102203 | 24102203 | ||
| 1210 | 1210 | 1898-11-19 | 4 | a | Business officials appointed to supervise dealings in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102201 | 24102201 | ||
| 1211 | 1211 | 1898-11-19 | 4 | a-b | Mad omens signal a year of famine ahead for Guangdong. | http://trove.nla.gov.au/newspaper/page/24102201 | 24102201 | ||
| 1212 | 1212 | 1898-11-19 | 4 | b | Injury from accident luckily avoided in Yangtze River, Hankou. | http://trove.nla.gov.au/newspaper/page/24102201 | 24102201 | ||
| 1213 | 1213 | 1898-11-19 | 4 | b | Maid in Guangzhou found property that she has lost few days prior. | http://trove.nla.gov.au/newspaper/page/24102201 | 24102201 | ||
| 1214 | 1214 | 1898-11-19 | 4 | c | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102201 | 24102201 |
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]);