This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32627 | 32627 | 1917-10-27 | 7 | a | Tung Wah Times increases its prices for subscription and their notice. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095887 | 24095887 | |
32628 | 32628 | 1917-10-27 | 7 | a-c | Australia news/ Strike in New South Wales comes to an end. Donations to the families of strikers. Flooding in Murray River. Smoking banned in Sydney harbour. Liner steamship Taiyuan on the schedule. Chinese laundry man Liu Fu is murdered in Launceston, Tasmania. Chinese cart runs over a child in Sydney. Submarine fires at and sinks a merchant ship. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095887 | 24095887 | |
32629 | 32629 | 1917-10-27 | 7 | c | A certificate on the merits of Liang Chuang, jointly issued by Ye Bingnan and Zheng Fanchang of the New South Wales of Chinese Chamber of Commerce, and his contributions towards Wing On companies and the Chinese communities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095887 | 24095887 | |
32630 | 32630 | 1917-10-27 | 7 | c | New Zealand news/ Casualty statistics of the New Zealand army. New Zealand authority bars foreign migrants from joining the army. Authorities confiscate properties from the people who refuse to enlist for military service. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095887 | 24095887 | |
32631 | 32631 | 1917-10-27 | 7 | d | War clouds between the south and the north in China. | Britain | http://trove.nla.gov.au/newspaper/page/24095887 | 24095887 | |
32632 | 32632 | 1917-10-27 | 7 | d-e | Miscellaneous report on the Chinese officialdom. | China | http://trove.nla.gov.au/newspaper/page/24095887 | 24095887 |
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]);