This data as json, CSV (advanced)
Suggested facets: date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 2820 | 2820 | 1899-06-21 | 3 | b | Two robbers were arrested and charged with attacking Chinese man in South Melbourne. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2821 | 2821 | 1899-06-21 | 3 | b | A newspaper in Sydney was fined for defamation. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2822 | 2822 | 1899-06-21 | 3 | b | Korea leases out three ports to Russia for 12 years. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2823 | 2823 | 1899-06-21 | 3 | b | A commander of the Italian army was arrested by French forces. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2824 | 2824 | 1899-06-21 | 3 | b | Number of Chinese migrant in the USA. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2825 | 2825 | 1899-06-21 | 3 | b | Price of metal in London. | http://trove.nla.gov.au/newspaper/page/24102439 | 24102439 | ||
| 2826 | 2826 | 1899-06-21 | 3 | b | Fighting between USA troops and local forces in the Philippines. | 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]);