This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
46728 | 46728 | 1928-02-11 | 5 | a | Rumours on the rebellions in the south of the Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24098689 | 24098689 | |
46729 | 46729 | 1928-02-11 | 5 | a | Farewell in Shanghai for British military commander. | China | http://trove.nla.gov.au/newspaper/page/24098689 | 24098689 | |
46730 | 46730 | 1928-02-11 | 5 | a | Alliance of six provinces (Guangdong, Guangxi, Yunnan, Jiangxi, Hunan and Hubei) against Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24098689 | 24098689 | |
46731 | 46731 | 1928-02-11 | 5 | a | Suicides in New York and the report. | America | http://trove.nla.gov.au/newspaper/page/24098689 | 24098689 | |
46732 | 46732 | 1928-02-11 | 5 | a | German foreign minister is going to have a holiday in France. | Britain | http://trove.nla.gov.au/newspaper/page/24098689 | 24098689 | |
46741 | 46741 | 1928-02-11 | 7 | a | Australia news/ Chinese kitchen hand is killed in Newcastle. Ferry stops travelling to Parramatta. A tea party at the lian yi tang, association in Sydney of the Dongguan and Zengcheng fellows, and speakers include Zhu Songqing, Ye Bingnan, Guo Jiexiu, Ye Guo'en, Li Run, Chen Qin, and others. Insurance industry in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24098691 | 24098691 |
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]);