This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48828 | 48828 | 1930-01-25 | 5 | a | Hong Kong news/ Smallpox in Hong Kong. Fan Qiwu on the Guangdong finance. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099504 | 24099504 | |
48829 | 48829 | 1930-01-25 | 5 | b | Second part of report on the social custom in Tibet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099504 | 24099504 | |
48830 | 48830 | 1930-01-25 | 5 | b | Brothers in Baiquan county, Heilongjiang, swap their wives. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099504 | 24099504 | |
48831 | 48831 | 1930-01-25 | 5 | c | The murder of Xi Lusheng, comprador of the Hong Kong-Shanghai Banking Corporation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099504 | 24099504 | |
48832 | 48832 | 1930-01-25 | 5 | c | Matchmakers in the Penglai island, Shandong province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099504 | 24099504 | |
48833 | 48833 | 1930-01-25 | 5 | d | A case of kidnap in Nanjing for love. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099504 | 24099504 |
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]);