This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
50401 | 50401 | 1931-06-13 | 5 | a | Hong Kong news/ Hong Kong government denies any introduction of gold standard system. Jiang Jieshi's troops are approaching the Dayuling Mountain in Guangdong. Hong Kong police raid Red Pills drug smuggling chains. Many rickshaw pullers are changing their career. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090414 | 24090414 | |
50402 | 50402 | 1931-06-13 | 5 | c | The art of being an official: starting from women. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090414 | 24090414 | |
50403 | 50403 | 1931-06-13 | 5 | d | Flower in France. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090414 | 24090414 | |
50404 | 50404 | 1931-06-13 | 5 | d | Notices issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090414 | 24090414 |
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]);