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 |
---|---|---|---|---|---|---|---|---|---|
47018 | 47018 | 1928-05-12 | 2 | b | Editorial on the three disasters in China this year: famine refugees, corrupt officials and the political parties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098802 | 24098802 | |
47026 | 47026 | 1928-05-12 | 5 | b | First part of a survey on the tobacco production in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098803 | 24098803 | |
47028 | 47028 | 1928-05-12 | 5 | c | Story of a woman in Taishan county who marries an overseas Chinese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098803 | 24098803 | |
47032 | 47032 | 1928-05-12 | 7 | c | Australia news/ Chairman of the New South Wales Gardening Association requests to limit working hours for the Chinese gardeners. New bank opened in Sydney. Further report on the case of rape in Sydney. Booth collapses during a horse racing in Sydney. A female cashier in Brisbane is found embezzlement. Chinese gardener in New South Wales sues builder for irresponsibility. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098805 | 24098805 |
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]);