This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15589 | 15589 | 1906-04-21 | 3 | a | Manchuria has been reopened to the outside world after the Russo-Japanese War. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800956 | 26800956 | |
15601 | 15601 | 1906-04-21 | 5 | a | Second part of the report on Chinese consul to Mexico Liang Xun who is keen to win promotion and get rich, his comments on Kang Youwei and others, and his relationship with local Chinese communities there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800961 | 26800961 |
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]);