This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7664 | 7664 | 1901-05-15 | 2 | a-b | Imperial edicts on January 25 and 12. | China | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7665 | 7665 | 1901-05-15 | 2 | b-c | A public letter prepared by gentry in Shanghai to governors of Jiangsu, Hubei, Guangdong, and Shandong provinces. | China | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7666 | 7666 | 1901-05-15 | 2 | c-d | Yuan Shikai wrote to Liu Kunyi; Sun Jialai is on leave; Zhang Zhidong wants to resign; Yu Yinlin in court; Zeng Qi signs an agreement with Russia; China sent representative to Japan to apologise; Yan Xiu was arrested. | Other... | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7667 | 7667 | 1901-05-15 | 2 | d | A report on the international troops in China. | Britain | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7668 | 7668 | 1901-05-15 | 2 | d | Sydney will penalise those who spit on the sidewalk. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7669 | 7669 | 1901-05-15 | 2 | d | A young man in Sydney was punished for selling the bike he borrowed from his friend. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7670 | 7670 | 1901-05-15 | 2 | d | Sun Jialai and his story. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7671 | 7671 | 1901-05-15 | 2 | e | Female hero Xue Jinqin's speech at the rally in Purity Garden of Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7672 | 7672 | 1901-05-15 | 2 | e | A boy was poisoned to death in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7673 | 7673 | 1901-05-15 | 2 | e | An old maid in Prestons, Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7674 | 7674 | 1901-05-15 | 2 | e | A husband in Charters Towers, Queensland, shot and killed his wife. | Australia | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7675 | 7675 | 1901-05-15 | 2 | f | Railway workers in the Philippines are on strike. | Other... | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7676 | 7676 | 1901-05-15 | 2 | f | Disputes between Germany, America and Portugal. | Other... | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7677 | 7677 | 1901-05-15 | 2 | f | Emperor Guangxu is to punish officials whocolluded with the Boxers. | Australia | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7678 | 7678 | 1901-05-15 | 2 | f | Poems written by a Japanese author on the situations in China. | Japan | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 | |
7679 | 7679 | 1901-05-15 | 2 | f | Business regulations issued for Wuchang. | China | http://trove.nla.gov.au/newspaper/page/24100039 | 24100039 |
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]);