This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 4334 | 4334 | 1899-12-30 | 3 | a | Recent developments in the situations in the Philippines. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4335 | 4335 | 1899-12-30 | 3 | a | Britain may boycott the international fair in Paris. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4336 | 4336 | 1899-12-30 | 3 | a | It is rumoured that Li Hongzhang will be the governor of Guangdong. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4337 | 4337 | 1899-12-30 | 3 | a | Heat wave sweeps across Victoria. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4338 | 4338 | 1899-12-30 | 3 | a | The custom of kidnapping brides in Hunan province. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4339 | 4339 | 1899-12-30 | 3 | a | A man in India was kicked and injured by a peacock. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4340 | 4340 | 1899-12-30 | 3 | b | Greetings from a reader to Kang Youwei. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4341 | 4341 | 1899-12-30 | 3 | b | Bandits in Panyu county, Guangdong. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4342 | 4342 | 1899-12-30 | 3 | b-d | South Africa, more reports on the war between Britain and Transvaal. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4343 | 4343 | 1899-12-30 | 3 | d | Four girls were drowned in Sydney during the Christmas holiday. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4344 | 4344 | 1899-12-30 | 3 | d | Counterfeit bank notes have been found in Sydney. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4345 | 4345 | 1899-12-30 | 3 | d | A magistrate in Zhejiang province was executed for embezzlement. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 | ||
| 4346 | 4346 | 1899-12-30 | 3 | d | Mail from China awaits collection. | http://trove.nla.gov.au/newspaper/page/24102654 | 24102654 |
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]);