This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10527 | 10527 | 1902-05-07 | 3 | a | Jiang Yuchang, magistrate of Nanchang, Jiangxi province, refused to maintain his position during the Boxer chaos. | China | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10528 | 10528 | 1902-05-07 | 3 | a | A women's association has been set up in Fuzhou, Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10529 | 10529 | 1902-05-07 | 3 | a | Report on an army school in Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10530 | 10530 | 1902-05-07 | 3 | b | Stories of Liang Dingfen, magistrate of Wuchang. | China | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10531 | 10531 | 1902-05-07 | 3 | b | The progress of railway building from Hankou to Guangzhou. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10532 | 10532 | 1902-05-07 | 3 | b | Bandits and social security in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10533 | 10533 | 1902-05-07 | 3 | c | Mineral resources in Qingyuan county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10534 | 10534 | 1902-05-07 | 3 | c | Bandits in Dongguan, Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10535 | 10535 | 1902-05-07 | 3 | c | Report on forged imperial edicts in Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10536 | 10536 | 1902-05-07 | 3 | d | Strong wind in Britain. | Britain | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10537 | 10537 | 1902-05-07 | 3 | d | Peace negotiations on the war in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10538 | 10538 | 1902-05-07 | 3 | d | A Chinese in Sydney was penalised for fighting. | Australia | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10539 | 10539 | 1902-05-07 | 3 | d | A Chinese man living on Sussex Street, Sydney, is slowly dying in a Sydney hospital. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10540 | 10540 | 1902-05-07 | 3 | d | Two Chinese men in Sydney were hospitalised for illness. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10541 | 10541 | 1902-05-07 | 3 | d | British army's new uniform; Chinese government pays Boxer indemnity; Tsar of Russia is going to Moscow. | Other... | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10542 | 10542 | 1902-05-07 | 3 | e | Twenty-two Chinese return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 | |
10543 | 10543 | 1902-05-07 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100415 | 24100415 |
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]);