This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29758 | 29758 | 1915-03-13 | 7 | a-b | Australia news/ Ceng Yunpu, the general counsellor in Australia is to be counsellor of Fiji as well. Yuhe, a Chinese in Sydney was killed by robbers. Some 100 military doctors are to be enrolled in Australia for European War. Australian soldiers in Egypt are suffering flu and pneumonia. Seven Australian soldiers in Egypt were killed in climbing pyramid. Yong Qing and Ya Yang, father and son, are killed in Fiji. Pu Qing's house in Sydney is burnt due to his carelessness. Ceremony of China's Business and Trade Association in Sydney. Strong wind in But Hurst causing some loss. | Australia | http://trove.nla.gov.au/newspaper/page/24094772 | 24094772 |
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]);