This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4472 | 4472 | 1900-01-20 | 2 | d | Negotiations and fights between China and France in the Guangzhou Bay. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4473 | 4473 | 1900-01-20 | 2 | d | Ways to manufacture and use rubber. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4474 | 4474 | 1900-01-20 | 2 | d | Confucian temples and societies are being set up in Nanyang Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4475 | 4475 | 1900-01-20 | 2 | d | France requests two more regions outside Beijing from the Chinese government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102679 | 24102679 | |
4489 | 4489 | 1900-01-20 | 3 | d | A ship carrying Queensland soldiers to South Africa was on fire. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102678 | 24102678 | |
4490 | 4490 | 1900-01-20 | 3 | d | New South Wales dispatched three ships of soldiers to south Africa and took precaution against espionage activity. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102678 | 24102678 | |
4491 | 4491 | 1900-01-20 | 3 | d | Timetables detailing arrivals and departures of liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102678 | 24102678 |
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]);