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 |
|---|---|---|---|---|---|---|---|---|---|
| 2813 | 2813 | 1899-06-21 | 2 | e | An article written by Zhu Yutang advising Chinese to quit opium-smoking. | http://trove.nla.gov.au/newspaper/page/24102440 | 24102440 | ||
| 2837 | 2837 | 1899-06-21 | 3 | e | British government outraged at China's refusal to remove the Guangxi governor. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2838 | 2838 | 1899-06-21 | 3 | e | London prepares to open a river. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2839 | 2839 | 1899-06-21 | 3 | e | An old woman in Melbourne canot find her way home. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2840 | 2840 | 1899-06-21 | 3 | e | A suspect of in a murder case was detained in Brisbane. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2841 | 2841 | 1899-06-21 | 3 | e | Governor of Hubei province remains loyal to the nation. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 |
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]);