Article Index

5 rows where "date" is on date 1900-06-20 and source = "Other..."

Filter results

This data as json, CSV (advanced)

Suggested facets: page, column, page_url, trove_id, date (date)

Link rowid ▼ date page column title description source page_url trove_id
5522 5522 1900-06-20 2 f   European soldiers delayed their arrival in Beijing as railway was demolished; local residents in Yunnan kills foreign missionaries; Britain's responses to the Beijing situations; future development of China's situation; Chinese community in Columbia gathered and financially support reformers in China. Other... http://trove.nla.gov.au/newspaper/page/24102846 24102846
5523 5523 1900-06-20 3 a   Secret deals achieved between Russia and Korea. Other... http://trove.nla.gov.au/newspaper/page/24102845 24102845
5538 5538 1900-06-20 2 d   Famine and refugees in India. Other... http://trove.nla.gov.au/newspaper/page/24102846 24102846
5542 5542 1900-06-20 2 e   Foreigners in Tianjin hide their missions to escape Boxers; Russia and other countries are determined to take over fortifications in Dagukou near Tianjin; rumours on the whereabouts of the American female missionary in Conghua county, Guangdong, as she is not in Tianjin; Japanese and German troops arrived in Qingdao, Shandong province; Boxers burned all churches in Tianjin and Beijing; France moved its troops from Vietnam to China; British troops in Beijing; Sydney churches pray for the injured and dead in Beijing. Other... http://trove.nla.gov.au/newspaper/page/24102846 24102846
5549 5549 1900-06-20 3 a   Coal export from New Castle; a Chinese in Rockhampton died of epidemic disease; local products from New Zealand to be sold in London; population increases in Western Australia; electric lights to be used in Brisbane; a Russian ship caught fire on its way to Melbourne. Other... http://trove.nla.gov.au/newspaper/page/24102845 24102845

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 
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]);