This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
1335 | 1335 | 1898-12-07 | 2 | a-b | Savage bandits infiltrate border area between Qingyuan and Yingde counties. | http://trove.nla.gov.au/newspaper/page/24102223 | 24102223 | ||
1336 | 1336 | 1898-12-07 | 2 | b | Rich man in Nanhai replaces his daughter with maid as bride. | http://trove.nla.gov.au/newspaper/page/24102223 | 24102223 | ||
1337 | 1337 | 1898-12-07 | 2 | b-c | Group of bandits loot shops and houses in Heshan and Xinhui area. | http://trove.nla.gov.au/newspaper/page/24102223 | 24102223 | ||
1338 | 1338 | 1898-12-07 | 2 | c | Qing Qin Wang is ready to help His Imperial Majesty, he also suggested that Chinese soldiers should be employed to protect foreign embassies; Empress Dowager approved that His Majesty to meet foreign diplomats, the first was the one from France; Empress is ready to give some power back to the Emperor. | http://trove.nla.gov.au/newspaper/page/24102223 | 24102223 | ||
1339 | 1339 | 1898-12-07 | 2 | c-d | Old maid in Guangzhou and young man collaborate to gain wealth. | http://trove.nla.gov.au/newspaper/page/24102223 | 24102223 | ||
1340 | 1340 | 1898-12-07 | 2 | d | Sichuan discovers rich gold resources, foreign expert invited to make further investigation. | http://trove.nla.gov.au/newspaper/page/24102223 | 24102223 | ||
1341 | 1341 | 1898-12-07 | 2 | d-e | Two hands and two legs were found Melbourne beach. | http://trove.nla.gov.au/newspaper/page/24102223 | 24102223 | ||
1342 | 1342 | 1898-12-07 | 2 | e | Chinese in Gildandra, NSW, penalised for gambling. | http://trove.nla.gov.au/newspaper/page/24102223 | 24102223 | ||
1343 | 1343 | 1898-12-07 | 2 | e-f | Chinese in Sydney fined for talking dirty to women. | http://trove.nla.gov.au/newspaper/page/24102223 | 24102223 | ||
1344 | 1344 | 1898-12-07 | 2 | f | Robbery case in Guangzhou. | http://trove.nla.gov.au/newspaper/page/24102223 | 24102223 | ||
1345 | 1345 | 1898-12-07 | 2 | f | Xu Yingkui appoints Governor of Zhejiang and Fujian. | http://trove.nla.gov.au/newspaper/page/24102223 | 24102223 |
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]);