This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53250 | 53250 | 1933-09-02 | 6 | a | A conference of the Pacific countries to be held in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53251 | 53251 | 1933-09-02 | 6 | a | Oppositions to the international peace conference in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53252 | 53252 | 1933-09-02 | 6 | c | Floods of the Yellow River. | China | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53253 | 53253 | 1933-09-02 | 6 | d | Rebellions of the Muslims in Xinjiang area, northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53254 | 53254 | 1933-09-02 | 6 | d | Japanese navy and their exercise. | Japan | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 | |
53255 | 53255 | 1933-09-02 | 6 | e | Australia news/ Chinese gardener dies in Sydney mysteriously. An armed robbery of gambling den in Sydney. Earthquake in Victoria. The death of Huang Si, Chinese businessman in Sydney and accountant of the Chinese Baptism Church. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091354 | 24091354 |
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]);