This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29738 | 29738 | 1915-03-13 | 2 | a-b | Comment: Look back on 1914 on Chinese New Year Eve. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094769 | 24094769 | |
29756 | 29756 | 1915-03-13 | 6 | a-b | President Yuan Shikai's orders on official promotions, people's education, pardoning followers of bandits parties. | China | http://trove.nla.gov.au/newspaper/page/24094773 | 24094773 | |
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 | |
29765 | 29765 | 1915-03-13 | 8 | a-b | The notice of Chinese consul general in Australia for awarding the donators by Chinese government, names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094775 | 24094775 |
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]);