This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45059 | 45059 | 1926-08-14 | 7 | a-b | Australia news/ Counterfeit bank notes found in Sydney. Business in Sydney. Pacific Conference to be held in Guangzhou next year. Telephone communication in Sydney and the problems. Poor harvest of vegetables in New South Wales. Attention to the income tax payer. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101667 | 24101667 | |
45060 | 45060 | 1926-08-14 | 7 | b | Turbulent political situation in Soviet Russia. | Britain | http://trove.nla.gov.au/newspaper/page/24101667 | 24101667 | |
45061 | 45061 | 1926-08-14 | 7 | b | A German man is arrested in Fuzhou, of Fujian province, and the investigation. | Britain | http://trove.nla.gov.au/newspaper/page/24101667 | 24101667 | |
45062 | 45062 | 1926-08-14 | 7 | b | Bandits in Qingdao, of Shandong province, murder German man. | China | http://trove.nla.gov.au/newspaper/page/24101667 | 24101667 | |
45063 | 45063 | 1926-08-14 | 7 | b | A foreigner is injured in Shanghai by bandits. | China | http://trove.nla.gov.au/newspaper/page/24101667 | 24101667 | |
45064 | 45064 | 1926-08-14 | 7 | c | Moscow denies political turbulence. | Britain | http://trove.nla.gov.au/newspaper/page/24101667 | 24101667 | |
45065 | 45065 | 1926-08-14 | 7 | c | Soviet Russia recalls its ambassador from China. | China | http://trove.nla.gov.au/newspaper/page/24101667 | 24101667 | |
45066 | 45066 | 1926-08-14 | 7 | c | A notice for the English and Chinese night schools at the Chinese Presbyterian church in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101667 | 24101667 |
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]);