This data as json, CSV (advanced)
Suggested facets: date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 2349 | 2349 | 1899-04-29 | 3 | b | Russia forces Finish people to learn Russian language. Response from Finland and Sweden. | http://trove.nla.gov.au/newspaper/page/24102379 | 24102379 | ||
| 2350 | 2350 | 1899-04-29 | 3 | b | Japan increases its tax on all imports. | http://trove.nla.gov.au/newspaper/page/24102379 | 24102379 | ||
| 2351 | 2351 | 1899-04-29 | 3 | b | Mr Chen Kongxiang, from Melbourne, returns to China with honour. He talks with Zheng Lu at the newspaper office. Other passengers include six New Zealanders, twenty-seven passengers from Melbourne, and Mr Huang Ning, native of Xinhui. | http://trove.nla.gov.au/newspaper/page/24102379 | 24102379 | ||
| 2352 | 2352 | 1899-04-29 | 3 | b | France plans to use radios for military purpose. | http://trove.nla.gov.au/newspaper/page/24102379 | 24102379 |
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]);