This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7249 | 7249 | 1901-03-20 | 2 | d | The Prince does not like to read books; houses in shortage; Empress attempts to call in Liu Kunyi but was stopped by Rong Lu; more refugees from the famine area; some gentry and scholars suggest moving the court to Chengdu. | China | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7250 | 7250 | 1901-03-20 | 2 | d | Li Hongzhang and Prince Qing have approved the draft peace agreement with foreign governments. | China | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7251 | 7251 | 1901-03-20 | 2 | d | A foreign newspaper published a cartoon picture of the Empress Dowager. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7252 | 7252 | 1901-03-20 | 2 | d | A report on Prince Duan's (Duang Wang) misfortune in Gansu province. | Australia | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7271 | 7271 | 1901-03-20 | 3 | d | Australian soldiers are returning from China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099975 | 24099975 | |
7272 | 7272 | 1901-03-20 | 3 | d | Many people infected with flu in Britian. | Britain | http://trove.nla.gov.au/newspaper/page/24099975 | 24099975 | |
7273 | 7273 | 1901-03-20 | 3 | d | A shire in Britain builds houses for the poor; a rich man in America made donations to hospitals. | Other... | http://trove.nla.gov.au/newspaper/page/24099975 | 24099975 | |
7274 | 7274 | 1901-03-20 | 3 | d | Japanese ambassador to Beijing talks about China. | Japan | http://trove.nla.gov.au/newspaper/page/24099975 | 24099975 | |
7275 | 7275 | 1901-03-20 | 3 | d | Corrections from the Tung Wah to an article in the previous issue. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099975 | 24099975 | |
7276 | 7276 | 1901-03-20 | 3 | d | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099975 | 24099975 | |
7277 | 7277 | 1901-03-20 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099975 | 24099975 |
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]);