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 |
---|---|---|---|---|---|---|---|---|---|
11393 | 11393 | 1903-01-17 | 2 | a | One of the major problems facing China is how to manage its local governors and imperial commissioners. | Japan | http://trove.nla.gov.au/newspaper/page/26800155 | 26800155 | |
11394 | 11394 | 1903-01-17 | 2 | a | Yuan Shikai and Zhang Zhidong talk politics in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/26800155 | 26800155 | |
11395 | 11395 | 1903-01-17 | 2 | a | Opening ceremony for Beijing University; enrolment figures. | China | http://trove.nla.gov.au/newspaper/page/26800155 | 26800155 | |
11396 | 11396 | 1903-01-17 | 2 | a | Celebrations for the 70th birthday of Empress Dowager. | China | http://trove.nla.gov.au/newspaper/page/26800155 | 26800155 | |
11413 | 11413 | 1903-01-17 | 3 | a | A passenger on an ocean liner died on the way from Sydney to Hong Kong. | Australia | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11414 | 11414 | 1903-01-17 | 3 | a | Zhang Zhidong wants to resign. | Australia | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11415 | 11415 | 1903-01-17 | 3 | a | British government tries to improve their business in China. | Britain | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11417 | 11417 | 1903-01-17 | 3 | a | Italian customs officer found dogs used in smuggling racket. | Other... | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11418 | 11418 | 1903-01-17 | 3 | a | A new balloon made in France. | Other... | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11419 | 11419 | 1903-01-17 | 3 | a | Zhang Zhidong has been awarded another title. | China | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11420 | 11420 | 1903-01-17 | 3 | a | Shipyard workers in London are on strike. | Britain | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11421 | 11421 | 1903-01-17 | 3 | a | Russian agricultural experts visit Australia. | Australia | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11422 | 11422 | 1903-01-17 | 3 | a | Iron production in New South Wales decreases. | Australia | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11423 | 11423 | 1903-01-17 | 3 | a | A charity institution will be established in memory of Queen Victoria. | Australia | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 | |
11424 | 11424 | 1903-01-17 | 3 | a | British in South Africa. | Britain | http://trove.nla.gov.au/newspaper/page/26800154 | 26800154 |
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]);