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 |
|---|---|---|---|---|---|---|---|---|---|
| 1135 | 1135 | 1898-11-12 | 3 | a | Governments in Nanhai and Panyu counties pursue family members of Kang Youwei and Liang Qichao. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
| 1136 | 1136 | 1898-11-12 | 3 | a-b | Young woman and and matchmaker collaborate in order to make money from men. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
| 1137 | 1137 | 1898-11-12 | 3 | b | International relations, Japanese government sends representative to visit China, greeted with welcoming ceremony. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
| 1138 | 1138 | 1898-11-12 | 3 | b-c | Man in Guangzhou quit opium smoking and wrote poems. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
| 1139 | 1139 | 1898-11-12 | 3 | c | Man in Dongguan faces disaster after trying to remarry. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
| 1140 | 1140 | 1898-11-12 | 3 | c-d | Merry nun in Guangzhou married finally. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
| 1141 | 1141 | 1898-11-12 | 3 | d-e | Gangsters, bandits discovered near Beijing; Chinese ambassador to Russia and Germany, Mr Xu Jingcheng, recalled; Japanese envoy visits China with letter from Japanese Emperor. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
| 1142 | 1142 | 1898-11-12 | 3 | e | White ants in India destroy grains. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
| 1143 | 1143 | 1898-11-12 | 3 | e | Daughter-in-law and her new life; fighting between two family clans. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
| 1144 | 1144 | 1898-11-12 | 3 | f | American oil ship from New York to Yokohama changes its route to Adelaide due to bad weather. | http://trove.nla.gov.au/newspaper/page/24102196 | 24102196 | ||
| 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 | ||
| 1146 | 1146 | 1898-11-12 | 2 | b | Chinese man arrested in NSW, fined 50 pounds for poll tax evasion. | http://trove.nla.gov.au/newspaper/page/24102195 | 24102195 | ||
| 1147 | 1147 | 1898-11-12 | 2 | b-c | Mr Liu in Liuan, Anhui province, murders his uncle and three cousins. | http://trove.nla.gov.au/newspaper/page/24102195 | 24102195 | ||
| 1148 | 1148 | 1898-11-12 | 2 | c-d | Fortune-teller in Shanghai correctly forecasts Mr Liang Qichao's misfortune. | http://trove.nla.gov.au/newspaper/page/24102195 | 24102195 | ||
| 1149 | 1149 | 1898-11-12 | 2 | d | Guangzhou introduces new insurance regulation to protect against public property being destroyed by fire. | http://trove.nla.gov.au/newspaper/page/24102195 | 24102195 | ||
| 1150 | 1150 | 1898-11-12 | 2 | d-e | Tragedy of burglary and murder near Shanghai. | http://trove.nla.gov.au/newspaper/page/24102195 | 24102195 | ||
| 1151 | 1151 | 1898-11-12 | 2 | e-f | Friendship between two Chinese fellows in Maitland, New South Wales. | http://trove.nla.gov.au/newspaper/page/24102195 | 24102195 | ||
| 1152 | 1152 | 1898-11-12 | 2 | f | Mr Yang Guancai, a Christian and philanthropist in Sydney Chinese community, is returning to China with honour. | http://trove.nla.gov.au/newspaper/page/24102195 | 24102195 | ||
| 1153 | 1153 | 1898-11-12 | 2 | f | Antiquities unearthed in Ruian, Zhejiang province. | http://trove.nla.gov.au/newspaper/page/24102195 | 24102195 | ||
| 1154 | 1154 | 1898-11-12 | 4 | a | Company in Guangzhou, with approval from the Government, is to undertake gambling project. | http://trove.nla.gov.au/newspaper/page/24102193 | 24102193 | ||
| 1155 | 1155 | 1898-11-12 | 4 | a-b | Parting poems by Chen Tianfu to farewell Mr Yang Guancai, returning to China. | http://trove.nla.gov.au/newspaper/page/24102193 | 24102193 | ||
| 1156 | 1156 | 1898-11-12 | 4 | b | Big fire on George Street, Sydney. | http://trove.nla.gov.au/newspaper/page/24102193 | 24102193 | ||
| 1157 | 1157 | 1898-11-12 | 4 | b-c | Several gamblers in Guangzhou under custody. | http://trove.nla.gov.au/newspaper/page/24102193 | 24102193 | ||
| 1158 | 1158 | 1898-11-12 | 4 | c | Prices of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102193 | 24102193 |
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]);