This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 154 | 154 | 1898-07-13 | 3-2 | f-a | Master approved of Buddhist nun in Guangdong marrying. | http://trove.nla.gov.au/newspaper/page/24102060 | 24102060 | ||
| 189 | 189 | 1898-07-16 | 3-2 | f-a | Beautiful woman in USA went to Washington to seek a husband. | http://trove.nla.gov.au/newspaper/page/24102064 | 24102064 | ||
| 227 | 227 | 1898-07-20 | 3-2 | f-a | Thief, who stole from Chinese, caught in Adelaide. | http://trove.nla.gov.au/newspaper/page/24102068 | 24102068 | ||
| 298 | 298 | 1898-07-23 | 3-2 | f-a | Bandit leader in Xiangshan arrested while preparing future crime. | http://trove.nla.gov.au/newspaper/page/24102072 | 24102072 | ||
| 333 | 333 | 1898-07-30 | 3-2 | f-a | Businessman in Sydney penalised for employing child labour. | http://trove.nla.gov.au/newspaper/page/24102080 | 24102080 | ||
| 377 | 377 | 1898-08-03 | 3-2 | f-a | Two electricity companies, located in Melbourne and Auckland, announce huge half-yearly profits. | http://trove.nla.gov.au/newspaper/page/24102084 | 24102084 | ||
| 411 | 411 | 1898-08-06 | 3-2 | f-a | Statistics on Japan's geography, population, etc. | http://trove.nla.gov.au/newspaper/page/24102088 | 24102088 | ||
| 450 | 450 | 1898-08-10 | 3-2 | f-a | Germany plans to hold solemn funeral for Bismarck. | http://trove.nla.gov.au/newspaper/page/24102092 | 24102092 | ||
| 483 | 483 | 1898-08-13 | 3-2 | f-a | Dog in Sydney. | http://trove.nla.gov.au/newspaper/page/24102096 | 24102096 | ||
| 522 | 522 | 1898-08-17 | 3-2 | f-a | Philanthropy, rich businessman in London helps build several charity foundations. | http://trove.nla.gov.au/newspaper/page/24102100 | 24102100 | ||
| 632 | 632 | 1898-08-27 | 3-2 | f-a | More people convert to Christian faith, church attendence and baptism rates increase. | http://trove.nla.gov.au/newspaper/page/24102112 | 24102112 | ||
| 666 | 666 | 1898-08-31 | 3-2 | f-a-b | First instalment of proposal to organise a branch of Quit-opium-smoking Association in Australia, written by Liu Yuanchun. | http://trove.nla.gov.au/newspaper/page/24102116 | 24102116 | ||
| 689 | 689 | 1898-09-03 | 3-2 | f-a | Advantages of reforming the Examination. | http://trove.nla.gov.au/newspaper/page/24102120 | 24102120 | ||
| 714 | 714 | 1898-09-07 | 3-2 | f-a | Missionaries clash with locals in Baoding and Tianjin, Hebei province. | http://trove.nla.gov.au/newspaper/page/24102124 | 24102124 | ||
| 762 | 762 | 1898-09-17 | 3-2 | f-a | Proposal to reform Imperial Examination submitted to His Majesty; Kang Youwei edits book with approval from His Majesty; plans for political reforms submitted to His Majesty. | http://trove.nla.gov.au/newspaper/page/24102132 | 24102132 | ||
| 784 | 784 | 1898-09-21 | 3-2 | f-a | Factors to consider when building ships. | http://trove.nla.gov.au/newspaper/page/24102136 | 24102136 | ||
| 809 | 809 | 1898-09-24 | 3-2 | f-a | Melbourne woman hangs herself because she has nothing to eat; another woman suicides because she cannot feed her six children. | http://trove.nla.gov.au/newspaper/page/24102140 | 24102140 | ||
| 835 | 835 | 1898-09-28 | 3-2 | f-a | Bandits return to Guangxi. | http://trove.nla.gov.au/newspaper/page/24102144 | 24102144 | ||
| 905 | 905 | 1898-10-08 | 3-2 | f-a | Fake herbal medicine and how to detect real medicine. | http://trove.nla.gov.au/newspaper/page/24102156 | 24102156 | ||
| 923 | 923 | 1898-10-12 | 3-2 | f-a | Story of henpecked man in Zhejiang province. | http://trove.nla.gov.au/newspaper/page/24102160 | 24102160 | ||
| 948 | 948 | 1898-10-15 | 3-2 | f-a | Three royal family members hurt by a diamond in Spain. | http://trove.nla.gov.au/newspaper/page/24102164 | 24102164 | ||
| 1017 | 1017 | 1898-10-26 | 3-2 | f-a | New monarch for Luzon. | http://trove.nla.gov.au/newspaper/page/24102176 | 24102176 | ||
| 1066 | 1066 | 1898-11-02 | 3-2 | e-f-a | Update on government efforts to catch Kang Youwei. | http://trove.nla.gov.au/newspaper/page/24102184 | 24102184 | ||
| 1118 | 1118 | 1898-11-09 | 3-2 | f-a | Gentry's mansion near Guangzhou was robbed. | http://trove.nla.gov.au/newspaper/page/24102192 | 24102192 | ||
| 1145 | 1145 | 1898-11-12 | 3-2 | f-a | Several Chinese diggers discover gold in Portland; Chinese man charged with murdering counterpart; Melbourne man arrives in Sydney with yacht. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
| 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 | ||
| 1224 | 1224 | 1898-11-23 | 3-2 | f-a | Women in Melbourne gives birth out of wedlock. | http://trove.nla.gov.au/newspaper/page/24102208 | 24102208 | ||
| 1281 | 1281 | 1898-11-30 | 3-2 | f-a | More women in Duanzhou abducted amidst social chaos. | http://trove.nla.gov.au/newspaper/page/24102216 | 24102216 | ||
| 1334 | 1334 | 1898-12-07 | 3-2 | f-a | Letter from Kang Youwei, published by Xinwen bao (Daily News) in Shanghai. | http://trove.nla.gov.au/newspaper/page/24102224 | 24102224 | ||
| 1381 | 1381 | 1898-12-14 | 3-2 | f-a | Sydney woman punished for theft; woman penalised for swearing in public. | http://trove.nla.gov.au/newspaper/page/24102232 | 24102232 | ||
| 1408 | 1408 | 1898-12-17 | 3-2 | f-a | Female employees in Shunde factory were sexually harassed. | http://trove.nla.gov.au/newspaper/page/24102236 | 24102236 | ||
| 1434 | 1434 | 1898-12-21 | 3-2 | f-a | Woman in Guangzhou remarries soon after death of her husband. | http://trove.nla.gov.au/newspaper/page/24102240 | 24102240 | ||
| 1487 | 1487 | 1898-12-31 | 3-2 | f-a | Maid in Guangzhou tells the truth, is cheated. | http://trove.nla.gov.au/newspaper/page/24102248 | 24102248 | ||
| 1588 | 1588 | 1899-01-14 | 3-2 | f-a | Medical discovery, vaccination very effective way to prevent smallpox. | http://trove.nla.gov.au/newspaper/page/24102264 | 24102264 | ||
| 1615 | 1615 | 1899-01-18 | 3-2 | f-a | Strong gale sweeps across Wellington, damage caused. | http://trove.nla.gov.au/newspaper/page/24102268 | 24102268 | ||
| 1639 | 1639 | 1899-01-21 | 3-2 | f-a | Man working in Hong Kong finds haven of peace in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102272 | 24102272 | ||
| 1756 | 1756 | 1899-02-08 | 3-2 | f-a | Two girls drown while swimming in New Castle. | http://trove.nla.gov.au/newspaper/page/24102292 | 24102292 | ||
| 1777 | 1777 | 1899-02-18 | 3-2 | e-f-a | Farewell notice from Qin Chunxuan (fangbo) on his departure of Guangdong. | http://trove.nla.gov.au/newspaper/page/24102298 | 24102298 | ||
| 1833 | 1833 | 1899-02-25 | 3-2 | f-a | Story of women in Guangzhou brothel. | http://trove.nla.gov.au/newspaper/page/24102306 | 24102306 |
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]);