This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7581 | 7581 | 1901-05-01 | 2 | a | Imperial edicts on January 7. | China | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7582 | 7582 | 1901-05-01 | 2 | a-b | The first part of Yu Jiantang's article on the education system of China. | Japan | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7583 | 7583 | 1901-05-01 | 2 | b-d | An article, selected from a Japanese newspaper, discussing the situation in China's over the past few years. | Japan | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7584 | 7584 | 1901-05-01 | 2 | d | Foreign missionaries witness the execution of Yu Xian, Ying Nian and Zhao Shuqiao; Dong Fuxiang will be punished; Liu Kunyi's advice for new policies; Zhang Zhidong is ill; missionary case in Quzhou, Zhejiang province; Dong Fuxiang asks for provisions. | Other... | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7585 | 7585 | 1901-05-01 | 2 | d-e | Conditions of the withdrawal of foreign troops from Beijing; international troops added several more names to the list of Chinese officials wanted. | China | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7586 | 7586 | 1901-05-01 | 2 | e | Korean government applies for loans from foreign sources to build a railway. | Other... | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7588 | 7588 | 1901-05-01 | 2 | e | Imperial scholar Xu Renzhu, passed away in Hangzhou, Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7589 | 7589 | 1901-05-01 | 2 | e | A Turkish cargo ship sank into the Red Sea. | Australia | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7590 | 7590 | 1901-05-01 | 2 | e | Several people were detained for gambling on La Trobe Street, Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7591 | 7591 | 1901-05-01 | 2 | e | Some British people like to store wine for their children as a way to make money. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7592 | 7592 | 1901-05-01 | 2 | f | A comet was seen in some areas of New South Wales such as West Wylong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7593 | 7593 | 1901-05-01 | 2 | f | A man in America died during a boxing match on the platform. | America | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
7594 | 7594 | 1901-05-01 | 2 | f | Stories of the Prince Pu Jun who was assigned by Empress Dowager. | China | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 |
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]);