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 |
---|---|---|---|---|---|---|---|---|---|
47019 | 47019 | 1928-05-12 | 2 | c | The Comintern or Third International outlines its new policy for the communist movement in China. | Russia | http://trove.nla.gov.au/newspaper/page/24098802 | 24098802 | |
47023 | 47023 | 1928-05-12 | 3 | c | Fierce battles between Fengtian's Zhang Zuolin, Shanxi's Yan Xishan and Henan's Wu Peifu. | China | http://trove.nla.gov.au/newspaper/page/24098801 | 24098801 | |
47027 | 47027 | 1928-05-12 | 5 | c | A fun party for the service men in Guangzhou. | China | 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]);