This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32615 | 32615 | 1917-10-27 | 2 | a-c | Editorial by Tung Wah Times on the bandit disasters in various provinces. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095884 | 24095884 | |
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 | |
32634 | 32634 | 1917-10-27 | 8 | a-c | Beijing news/ Five ministries in Beijing set up auditing office. Foreign missions in Beijing meet Wang Daxie. Chinese government selects war observers to the World War I and the qualification assessment. Chinese President Feng Guozhang seeks to appoint new government advisers. The steamship company after China's declaration of war with Germany. Investigation on the secret societies (qing hong bang) in Shanghai. Zou Daoji suggests to pardon Zhang Xun. Deputy manager of the German-China Bank in Beijing is wanted. Flood in Taiyuan, capital of Shanxi province. China may have shortage of iron resource. Li Kaishen arrives Guangxi with a letter from Li Yuanhong. | China | http://trove.nla.gov.au/newspaper/page/24095890 | 24095890 |
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]);