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 |
---|---|---|---|---|---|---|---|---|---|
15634 | 15634 | 1906-05-05 | 3 | a | Further report on the earthquake in San Francisco. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800968 | 26800968 | |
15641 | 15641 | 1906-05-05 | 5 | a | Fourth 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/26800970 | 26800970 | |
15644 | 15644 | 1906-05-05 | 6 | a | Second part of the novel about a concubine with cruel fate. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800973 | 26800973 | |
15645 | 15645 | 1906-05-05 | 6 | a | Report on sale of shares of the Hankou-Guangzhou railway. Chinese communities in Australia purchase shares with enthusiasm. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800973 | 26800973 |
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]);