This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 1057 | 1057 | 1898-11-02 | 3 | a | As strong countries fight for more territories, cease-fire becomes increasingly difficult to establish. | http://trove.nla.gov.au/newspaper/page/24102184 | 24102184 | ||
| 1058 | 1058 | 1898-11-02 | 3 | a-b | Melbourne woman commits suicide. Her son passed away weeks before. | http://trove.nla.gov.au/newspaper/page/24102184 | 24102184 | ||
| 1059 | 1059 | 1898-11-02 | 3 | b | Sow bore more than ten piglets in Xinhui. | http://trove.nla.gov.au/newspaper/page/24102184 | 24102184 | ||
| 1060 | 1060 | 1898-11-02 | 3 | b-c | Business man from Xinhui caught after abducting woman from Nanhai. | http://trove.nla.gov.au/newspaper/page/24102184 | 24102184 | ||
| 1061 | 1061 | 1898-11-02 | 3 | c | Foot binding. Women freed their feet from binding and walked in public, ridiculed by passer-byers. | http://trove.nla.gov.au/newspaper/page/24102184 | 24102184 | ||
| 1062 | 1062 | 1898-11-02 | 3 | c-d | Two friends disagree, stay true to own opinions. | http://trove.nla.gov.au/newspaper/page/24102184 | 24102184 | ||
| 1063 | 1063 | 1898-11-02 | 3 | d | International relations, Britain and France disagree over issues in African and elsewhere. | http://trove.nla.gov.au/newspaper/page/24102184 | 24102184 | ||
| 1064 | 1064 | 1898-11-02 | 3 | d | Young man in Xinhui approaches young woman, refused. | http://trove.nla.gov.au/newspaper/page/24102184 | 24102184 | ||
| 1065 | 1065 | 1898-11-02 | 3 | e | International relations, Russia seeks privileged position in ties with China. | http://trove.nla.gov.au/newspaper/page/24102184 | 24102184 |
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]);