This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7247 | 7247 | 1901-03-20 | 2 | a-b | Notes on reading the imperial edicts of December 10, 1900. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7248 | 7248 | 1901-03-20 | 2 | c | Japanese newspapers analyse the current situation in China and China's future. | Japan | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7249 | 7249 | 1901-03-20 | 2 | d | The Prince does not like to read books; houses in shortage; Empress attempts to call in Liu Kunyi but was stopped by Rong Lu; more refugees from the famine area; some gentry and scholars suggest moving the court to Chengdu. | China | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7250 | 7250 | 1901-03-20 | 2 | d | Li Hongzhang and Prince Qing have approved the draft peace agreement with foreign governments. | China | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7251 | 7251 | 1901-03-20 | 2 | d | A foreign newspaper published a cartoon picture of the Empress Dowager. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7252 | 7252 | 1901-03-20 | 2 | d | A report on Prince Duan's (Duang Wang) misfortune in Gansu province. | Australia | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7253 | 7253 | 1901-03-20 | 2 | e | China and Korea have not signed the treaty presented by Russia; British ambassador sees off soldiers from New South Wales; German troops occupied Fenglong Mountain in Zhili province. | China | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7254 | 7254 | 1901-03-20 | 2 | e | A Sydney man was drowned in Manly beach. | Australia | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7255 | 7255 | 1901-03-20 | 2 | e | Two carriages collided on Sydney street. | Australia | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7256 | 7256 | 1901-03-20 | 2 | e | A doctor in London suggests a new gardening style. | Australia | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7257 | 7257 | 1901-03-20 | 2 | f | A young man was injured while working in a sugar factory. | Australia | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7258 | 7258 | 1901-03-20 | 2 | f | A Sydney man was robbed of his gold. | Australia | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 | |
7259 | 7259 | 1901-03-20 | 2 | f | Continued record of the treaty adopted by international peace conference on international disputes. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099976 | 24099976 |
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]);