This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10595 | 10595 | 1902-05-14 | 3 | a | Former governor of New South Wales is trying to have a portrait of the crowned King of England. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10596 | 10596 | 1902-05-14 | 3 | a | Dozens of train passengers in Belgium were injured in an accident. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10597 | 10597 | 1902-05-14 | 3 | a | The new alliance between Russia and France. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10598 | 10598 | 1902-05-14 | 3 | a | Bandits in Guangdong; influence of Boxer rebellion upon Guangdong province; National defence of China; Manchurian soldiers in Guangzhou; local officials in Guangdong are keen to implement new policies. | China | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10599 | 10599 | 1902-05-14 | 3 | b | Influence of Japan-Britain alliance upon the politics of Korea. | Japan | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10600 | 10600 | 1902-05-14 | 3 | b | Local residents of Hawaii organise a protest rally. | America | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10601 | 10601 | 1902-05-14 | 3 | b | Russian students protest against press censorship. | Britain | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10602 | 10602 | 1902-05-14 | 3 | c | The heavy burden of the Boxer indemnity may cause riots in both the south and north of China. | Britain | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10603 | 10603 | 1902-05-14 | 3 | c | Turks prepare to defend their country from possible invasion of Italy. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10604 | 10604 | 1902-05-14 | 3 | c | Governor General Lord Hopetoun reviews Australian troops departing for the Boer War, Transvaal, South Africa. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10605 | 10605 | 1902-05-14 | 3 | c | A Chinese house in Alexandria, New South Wales, to be demolished because of suspected epidemic infection. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10606 | 10606 | 1902-05-14 | 3 | d | A bank manager in Coonamble, New South Wales, committed suicide by shooting himself. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10607 | 10607 | 1902-05-14 | 3 | d | A Chinese man, Zan Chang, died in a traffic accident on Goulburn Street, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10608 | 10608 | 1902-05-14 | 3 | d | A restaurant on Castlereagh Street, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10609 | 10609 | 1902-05-14 | 3 | d | A volcano erupts in western India. | Britain | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10610 | 10610 | 1902-05-14 | 3 | e | Bandits in Guangxi province; international troops in Beijing and Tianjin. | Britain | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10611 | 10611 | 1902-05-14 | 3 | e | Zhou Fengzhen, a Chinese businessman in Bendigo, Victoria, is leaving for China. Parting poems on his departure written by Liu Xibo, Mai Mei, Wu E'lou and Cai Juexuan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 | |
10612 | 10612 | 1902-05-14 | 3 | e | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100423 | 24100423 |
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]);