This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32813 | 32813 | 1917-12-22 | 8 | a-b | A public notice issued by the Chinese-Australia Mail Steamship company in Sydney on the sales of shares, the establishment, budget, and prediction for profit. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095954 | 24095954 | |
32814 | 32814 | 1917-12-22 | 8 | b-c | Beijing news/ Feng Guozhang is considering to suppress rebels in the Southwest by force. Liu Guanxiong dispatches two warships to support Fujian. Mutiny in Jilin province. War disasters in Sichuan province. Opening ceremony of the provisional parliament in Beijing. Japan takes over sovereignty of Shandong province. Chen Jintao will appeal for the sentence. Li Yuanhong refuses to reply to Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24095954 | 24095954 | |
32815 | 32815 | 1917-12-22 | 8 | d | Guangdong news/ Appointments and removals of military staff in Guangdong. Qinzhou, Lianzhou and Gaozhou declare independence and their support to the central government in Beijing. Guangdong to be divided. Li Yaohan resigns. Chen Bingkun to leave Guangdong. Guangdong members for the provisional national parliament in Beijing. Civil corps in Xiangshan county. Bandits in Xiangshan county. | China | http://trove.nla.gov.au/newspaper/page/24095954 | 24095954 |
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]);