This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
12966 | 12966 | 1904-04-02 | 2 | c | Empress Dowager has been ordered to train more troops for the future. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800405 | 26800405 | |
12967 | 12967 | 1904-04-02 | 2 | c | New plan to train Chinese troops. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800405 | 26800405 | |
12968 | 12968 | 1904-04-02 | 2 | c | An imperial scholar reports on the possible influence of the Japan-Russia war upon China. | China | http://trove.nla.gov.au/newspaper/page/26800405 | 26800405 | |
12969 | 12969 | 1904-04-02 | 2 | c | French government advises Russia not to start a war with Japan. | China | http://trove.nla.gov.au/newspaper/page/26800405 | 26800405 | |
12970 | 12970 | 1904-04-02 | 2 | c | Russian in Manchuria are recruiting more Chinese soldiers. | China | http://trove.nla.gov.au/newspaper/page/26800405 | 26800405 | |
12971 | 12971 | 1904-04-02 | 2 | c | Governor Qin Chunxuan reports that it is hard to raise enough money needed to suppress bandits in Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/26800405 | 26800405 | |
12972 | 12972 | 1904-04-02 | 2 | c | Huang Zunxian has been invited to supervise the newly established Guangdong Public School (Guangdong gongxue). | China | http://trove.nla.gov.au/newspaper/page/26800405 | 26800405 | |
12987 | 12987 | 1904-04-02 | Suppl't | c | Report on Commercial News, a newspaper from Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800406 | 26800406 | |
12988 | 12988 | 1904-04-02 | Suppl't | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800406 | 26800406 | |
12989 | 12989 | 1904-04-02 | Suppl't | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800406 | 26800406 |
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]);