This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6438 | 6438 | 1900-11-17 | 2 | a | Imperial edicts on Boxer Uprising, negotiation with foreign government, etc. | China | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6439 | 6439 | 1900-11-17 | 2 | a-b | A London newspaper publishes an article on China affairs. | Britain | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6440 | 6440 | 1900-11-17 | 2 | b | A biography of Gang Yi. | China | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6441 | 6441 | 1900-11-17 | 2 | b-c | A reader in Queensland sent a map of China, especially Dagu fortifications, and claimed it was for military purposes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6442 | 6442 | 1900-11-17 | 2 | c | Report on battles in Beitang, near Tianjin. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6443 | 6443 | 1900-11-17 | 2 | c | Clashes between Chinese and Russian troops in Heilongjiang province, Chinese troops retreated; Russian troops keep moving forward and have taken over many places in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6444 | 6444 | 1900-11-17 | 2 | d | British Prime Minister on China issues and the peace negotiation. | Britain | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6445 | 6445 | 1900-11-17 | 2 | d | Tornado in Hong Kong and the disaster. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6446 | 6446 | 1900-11-17 | 2 | d | Churches were attacked while Chinese followers were harassed. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6447 | 6447 | 1900-11-17 | 2 | e | Bandits in Taiwan harassed Japanese troops there. | Japan | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6448 | 6448 | 1900-11-17 | 2 | e | A dragon boat was found in Sixian county, Anhui province, which was most probably left by Sui yangdi of Sui Dynasty. | China | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6449 | 6449 | 1900-11-17 | 2 | e | China and Russia signed an agreement under which whole Manchuria would be under protection of Russia; a Chinese military officer on his way from Xi'an to Chengdu in Sichuan province; Russia has transferred the railway from Dagu to Beijing to international troops; Li Hongzhang wrote to foreign missions in Beijing on the Baoding issue; Russia demands part of Tianjin. | Other... | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6450 | 6450 | 1900-11-17 | 2 | e | A crocodile and a tiger fought each other in Hong Kong and both died. | Other... | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6451 | 6451 | 1900-11-17 | 2 | e | A talented boy comments on the international fair in Paris. | Other... | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6452 | 6452 | 1900-11-17 | 2 | f | Humans are often more fragile than other animals. | Other... | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6453 | 6453 | 1900-11-17 | 2 | f | A man in Balwyn, Melbourne, commits suicide because he was unemployment. | Australia | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6454 | 6454 | 1900-11-17 | 2 | f | A woman in Sydney died in a train accident. | Australia | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6455 | 6455 | 1900-11-17 | 2 | f | An American ship sank into the ocean. | America | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 |
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]);