This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31801 | 31801 | 1916-12-09 | 7 | a-b | Australia news/ Result of the referendum on the compulsory enlistment in Australia. Trial on the union case. News on the strike of coal miners. Restrictions lifted on electricity usage. The man who murdered policeman is hanged. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095510 | 24095510 | |
31802 | 31802 | 1916-12-09 | 7 | b-c | News on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24095510 | 24095510 | |
31803 | 31803 | 1916-12-09 | 7 | c-d | Correspondence from Guangzhou/ Li Liejun, Zhu Qinglan, Tan Haoming, Yan Jiachi, Mo Rongxin and others offer their sacrifices to the Huanghuagang and the report. Yunnan troops in Guangzhou. Governor Zhu Qinglan after his arrival in Guangzhou. Youth association in Guangzhou. Welcome ceremony for Li Liejun. | China | http://trove.nla.gov.au/newspaper/page/24095510 | 24095510 | |
31804 | 31804 | 1916-12-09 | 7 | d | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. Mails for pickup at the Tung Wah Times. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095510 | 24095510 |
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]);