This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8642 | 8642 | 1901-09-25 | 3 | a | A fire in Zhaoqing, Guangdong province, burned down many shops. | China | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8643 | 8643 | 1901-09-25 | 3 | a | Flooding in Tongshan county, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8644 | 8644 | 1901-09-25 | 3 | a | A man in Shunde county, Guangdong, manufactured fake silk for export purpose. | China | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8645 | 8645 | 1901-09-25 | 3 | b | Chinese ambassador to America Wu Tingfang received a threatening letter before leaving for Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8646 | 8646 | 1901-09-25 | 3 | b | Some bandits are waiting for opportunity outside of Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8647 | 8647 | 1901-09-25 | 3 | b | Li Hongzhang was blamed; imperial doctors were called in for the Empress; Wang Wenshao on the way back to Beijing; Zhang Yeqiu's memorial report for reform; Liu Kunyi tries to re-organise army in that region. | China | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8648 | 8648 | 1901-09-25 | 3 | b | A Sydney businessman discussed with a journalist about the proposals to ban entry of Chinese and Japanese into Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8649 | 8649 | 1901-09-25 | 3 | c | A woman in Sydney was compensated for defamation. | Australia | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8650 | 8650 | 1901-09-25 | 3 | c-d | Mails from China waiting for pickup. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8651 | 8651 | 1901-09-25 | 3 | d | Representatives from Gibbs Bright & Co, Nippon Yusen Haisha Japan Mail Steamship Co, and China Navigation Co. went to see Prime Minister Barton on the new regulation to ban entry of Chinese into Australia. Record of their talks. | Australia | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8652 | 8652 | 1901-09-25 | 3 | d | Imperial carriage have been prepared for the return of Emperor Guangxu. | China | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 | |
8653 | 8653 | 1901-09-25 | 3 | d | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100172 | 24100172 |
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]);