This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8429 | 8429 | 1901-08-27 | 3 | a | Russia wants Xinjiang and the Niuzhuang port; black storm in Henan province; villagers organised to protest against new taxes. | China | |||
8430 | 8430 | 1901-08-27 | 3 | a | China and foreign envoys in Beijing further discussed the peace protocol. | China | |||
8431 | 8431 | 1901-08-27 | 3 | a | Germany started inland water transportation in Hunan province, China. | China | |||
8432 | 8432 | 1901-08-27 | 3 | b | Japan is preparing for the possible war with Russia. | Australia | |||
8433 | 8433 | 1901-08-27 | 3 | b | Competition between Russia and Britain on the Tianjin railway. | Britain | |||
8434 | 8434 | 1901-08-27 | 3 | b | A man in Bunbury, Western Australia, injured his brother while hunting together. | Australia | |||
8435 | 8435 | 1901-08-27 | 3 | b | Story of Zhou Fengzhen, a Chinese businessman in Melbourne. Poems by Zhou Fengzhen and Liu Xibo. | Tung Wah | |||
8436 | 8436 | 1901-08-27 | 3 | c | Germany and the Chinese community there are preparing to welcome Prince Chun. | Britain | |||
8437 | 8437 | 1901-08-27 | 3 | c | Royal government in Melbourne offered rewards to capture three robbers. | Australia | |||
8438 | 8438 | 1901-08-27 | 3 | c | Recommended by See Yup Society and Chinese Empire Reform Association in Melbourne, Sydney Chinese community had a meeting on the proposal (in the parliament) to ban Chinese entry in the future. | Tung Wah | |||
8439 | 8439 | 1901-08-27 | 3 | c | Imports and exports of the New South Wales. | Australia | |||
8440 | 8440 | 1901-08-27 | 3 | d | Yellow River and disasters it brought. | China | |||
8441 | 8441 | 1901-08-27 | 3 | d | Gold price in Hong Kong | Tung Wah | |||
8442 | 8442 | 1901-08-27 | 3 | e | Liner timetable. | Tung Wah |
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]);