This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50018 | 50018 | 1931-02-21 | 5 | a | Hong Kong news/ Huang Shaoxiong in Hong Kong on his way to the north. Smuggling of opium and weapons in Hong Kong. Firms are leaving Macao for Hong Kong in order to avoid heavy taxes. The 48th seminar on Confucianism in the Confucian College, Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090283 | 24090283 | |
50019 | 50019 | 1931-02-21 | 5 | c | Russian professor finds ancient battle fields in central Asia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090283 | 24090283 | |
50020 | 50020 | 1931-02-21 | 5 | e | Europe has more women than men. Tragedy of a test marriage in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090283 | 24090283 | |
50021 | 50021 | 1931-02-21 | 5 | e | A notice by the zhi gong tang in Sydney for a picnic. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090283 | 24090283 |
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]);