This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10727 | 10727 | 1902-05-28 | 3 | a | Former governor of New South Wales was engaged in London. | Australia | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10728 | 10728 | 1902-05-28 | 3 | a | Recent relations between France and Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10729 | 10729 | 1902-05-28 | 3 | a | A local governor in Russia received blackmail letter from a revolutionary party. | Russia | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10730 | 10730 | 1902-05-28 | 3 | a | China and Britain sign a treaty on railway building in north China. | Britain | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10731 | 10731 | 1902-05-28 | 3 | b | Foreign countries require China to pay gold rather than silver for the Boxer indemnity. | Britain | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10732 | 10732 | 1902-05-28 | 3 | b | Bandits in south Zhili province sabotage railway from Beijing to Hankou. | Britain | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10733 | 10733 | 1902-05-28 | 3 | b | Yuan Shikai and the railway building in north China. | China | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10734 | 10734 | 1902-05-28 | 3 | b | Weather changes in Hong Kong, Australia, Japan and China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10735 | 10735 | 1902-05-28 | 3 | b | A jeweller's shop on Russell Street, Melbourne, was robbed and the owner was seriously injured. | Australia | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10736 | 10736 | 1902-05-28 | 3 | c | Two unmarried women in France were charged with swindling. | Britain | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10737 | 10737 | 1902-05-28 | 3 | c | Lord Hopetoun, Governor General of Australia, is to return to Britain. | Australia | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10738 | 10738 | 1902-05-28 | 3 | c | Local residents riot in Vietnam. | Britain | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10739 | 10739 | 1902-05-28 | 3 | c | Refugees flee following the eruption of a volcano in India. | Britain | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10740 | 10740 | 1902-05-28 | 3 | d | Local residents riot in Haicheng (probably Chenghai), Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10741 | 10741 | 1902-05-28 | 3 | d | Books and writing on current affairs are popular in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10742 | 10742 | 1902-05-28 | 3 | d | Liang Qichao is going to visit America. | America | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10743 | 10743 | 1902-05-28 | 3 | d | Six Chinese return home. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 | |
10744 | 10744 | 1902-05-28 | 3 | d-e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100439 | 24100439 |
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]);