This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8822 | 8822 | 1901-10-16 | 2 | a | Imperial edicts on July 19 and 20. | China | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8823 | 8823 | 1901-10-16 | 2 | a-b | The first part of report from Liu Kunyi and Zhang Zhidong on cultivating young people. | China | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8824 | 8824 | 1901-10-16 | 2 | b-c | An essay on civil rights. | China | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8825 | 8825 | 1901-10-16 | 2 | c | New schedule for the Emperor to return. | China | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8826 | 8826 | 1901-10-16 | 2 | c | Reports on international troops in Beijing. | Australia | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8827 | 8827 | 1901-10-16 | 2 | c | A girl, Li Zhiying, of Gutian county, Fujian province, is going to study in America. | China | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8828 | 8828 | 1901-10-16 | 2 | c | Capital of Hungary has a telephone office which provides news services. | Other... | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8829 | 8829 | 1901-10-16 | 2 | d | The war between Britain and Transvaal. South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8830 | 8830 | 1901-10-16 | 2 | d | A worksite accident in North Fremantle, Western Australia, claimed several lives. | Australia | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8831 | 8831 | 1901-10-16 | 2 | d | A racist organisation, White Boxers, hold a gathering in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8832 | 8832 | 1901-10-16 | 2 | d | Chinese Li Pu in Wyalong, New South Wales, was murdered by an Indian man who is now under custody and faces trial. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8833 | 8833 | 1901-10-16 | 2 | e | Residents of Boston donated to the fund of ransom money needed to secure the freedom of a female American missionary. | America | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8834 | 8834 | 1901-10-16 | 2 | e | Pope of Vatican is the richest man in the world; a description of his palace. | Malaysia | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8835 | 8835 | 1901-10-16 | 2 | e | A bridge in New York collapsed. | America | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8836 | 8836 | 1901-10-16 | 2 | f | British Prime Minister comments on international and British troops in China. | Japan | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8837 | 8837 | 1901-10-16 | 2 | f | Zhang Zhidong had a dinner and talk with Liang Dingfen. | China | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8838 | 8838 | 1901-10-16 | 2 | f | The third part of a report on the rebellions on the border of China. | China | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 |
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]);