This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53235 | 53235 | 1933-09-02 | 2 | e | Guangdong troops in Fujian suppress the communists. | China | http://trove.nla.gov.au/newspaper/page/24091350 | 24091350 | |
53236 | 53236 | 1933-09-02 | 2 | e | Relief Committee set up in the war zones of north China. | China | http://trove.nla.gov.au/newspaper/page/24091350 | 24091350 | |
53242 | 53242 | 1933-09-02 | 3 | e | Jewish people in Germany and their life. | Germany | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53243 | 53243 | 1933-09-02 | 3 | e | Ma Zhanshan tours Mogan Mountain in Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53244 | 53244 | 1933-09-02 | 3 | e | France to expand its overseas colonies. | France | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53245 | 53245 | 1933-09-02 | 3 | e | Japanese to build oil wells in Rehe province, north China. | China | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
53248 | 53248 | 1933-09-02 | 5 | e | Government officials are not civil servants. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091351 | 24091351 | |
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]);