This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 4110 | 4110 | 1899-11-25 | 2 | a-b | A letter sent to foreign ambassadors in Beijing seeking their help to restore power of the Emperor. Diplomats from Britain, Russia, Germany, France, America, Japan, and others. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4111 | 4111 | 1899-11-25 | 2 | b-c | Notes written by a tourist to Canada. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4112 | 4112 | 1899-11-25 | 2 | c | A telegram sent to celebrate the birthday of the Emperor by Chinese merchants in Singapore. And the name list of the merchants. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4113 | 4113 | 1899-11-25 | 2 | d | A shark was caught near Adelaide. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4114 | 4114 | 1899-11-25 | 2 | d | Revenue from stamp duty in New South Wales. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4115 | 4115 | 1899-11-25 | 2 | d | Customs offices in Townsville confiscated tobacco smuggled in two ships. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4116 | 4116 | 1899-11-25 | 2 | e | The tariff income of Sydney. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4117 | 4117 | 1899-11-25 | 2 | e | New schedule for the tram on George St, Sydney. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4118 | 4118 | 1899-11-25 | 2 | e | The local residents in Fujian province resist the settlement of Japanese there. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4119 | 4119 | 1899-11-25 | 2 | e | A baby boy was abandoned in a doctor's garden in Sydney. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4120 | 4120 | 1899-11-25 | 2 | f | A woman in Sydney died after a tooth extraction. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4121 | 4121 | 1899-11-25 | 2 | f | Chinese businessman, Mr Lin, was saved by local people after a near-fatal experience in the mountains of Thailand. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4122 | 4122 | 1899-11-25 | 2 | f | Potato harvest in Grafton, NSW. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4123 | 4123 | 1899-11-25 | 2 | f | A young man in Melbourne was killed by an acquaintance when hunting. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 | ||
| 4124 | 4124 | 1899-11-25 | 2 | f | Western and lunar calendar coincide next month. | http://trove.nla.gov.au/newspaper/page/24102617 | 24102617 |
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]);