This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50090 | 50090 | 1931-03-14 | 5 | a | Hong Kong news/ Gold price in Hong Kong. Textile industry in Hong Kong. Bandits and their kidnap in Hong Kong. Contract to be revised for the railway from Guangzhou to Kowloon. Sugar industry in the upsurge of gold prices. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090309 | 24090309 | |
50091 | 50091 | 1931-03-14 | 5 | c | A woman in Guangxi province applies for divorce because her husband is overweighted. Strange mountain cave found in Taishan county, Guangdong. Virginity tested on one of the Ryukyu islands. Visit to a temple in Qujiang county, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090309 | 24090309 | |
50092 | 50092 | 1931-03-14 | 5 | e | A notice by the Dongguan gong yi tang in Sydney on the transfer of remains of their deceased fellows back to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090309 | 24090309 |
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]);