This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53231 | 53231 | 1933-09-02 | 2 | a | Second part of an editorial on Japanese conspiracy of their proposed Asian alliance. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091350 | 24091350 | |
53247 | 53247 | 1933-09-02 | 5 | b | Writings by Liang Chaowen, a native of Taishan county, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091351 | 24091351 | |
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]);