This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38784 | 38784 | 1922-05-27 | 7 | a | Three bandits are arrested in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093989 | 24093989 | |
38785 | 38785 | 1922-05-27 | 7 | a | A man in Sydney is sentenced to death for murder. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093989 | 24093989 | |
38786 | 38786 | 1922-05-27 | 7 | a | Passengers on board of St Albion are found smallpox. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093989 | 24093989 | |
38787 | 38787 | 1922-05-27 | 7 | a | Forth white men are arrested and penalised for gambling in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093989 | 24093989 | |
38788 | 38788 | 1922-05-27 | 7 | b | University of Sydney celebrates its anniversary. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093989 | 24093989 | |
38789 | 38789 | 1922-05-27 | 7 | b | Bulgaria declares a republic after a Communist coup. | Other... | http://trove.nla.gov.au/newspaper/page/24093989 | 24093989 | |
38790 | 38790 | 1922-05-27 | 7 | b | A boy in Bombay, India, remembers his savings deposited in the last life. | Other... | http://trove.nla.gov.au/newspaper/page/24093989 | 24093989 | |
38791 | 38791 | 1922-05-27 | 7 | c | News in brief/ Foreign missions in Beijing jointly give warnings to the Beijing government. Wu Peifu to convene a military conference in Baoding, Hebei province. Zhang Zuolin's troops enter the Shanhaiguan. Clash between Wu Peifu and Zhao Jie. Li Yuanhong, Wang Shizhen and Zhang Qian on peace in China. Zhang Xun is back to Xuzhou, of Jiangsu province. Zhang Zuolin, Duan Qirui and Wu Peifu and their interest conflict. | China | http://trove.nla.gov.au/newspaper/page/24093989 | 24093989 | |
38792 | 38792 | 1922-05-27 | 7 | d | Fishing guide. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093989 | 24093989 |
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]);