This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31058 | 31058 | 1916-03-25 | 8 | a-c | Chinese central government in Beijing asks local provinces to send their representatives for a discussion on the state system, and comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095208 | 24095208 | |
31076 | 31076 | 1916-03-25 | 8 | a-b | Beijing news/ Yuan Shikai helps the poor. Li Yuanhong refuses to congratulate Yuan Shikai. Another method to change the Chinese calendar by force. Li Liejun and Cai E to lead armies out of Yunnan province and on their way to the north. Volunteer army in Yunnan province after its independence. Chinese government to mediate the Yunnan disputes. | China | http://trove.nla.gov.au/newspaper/page/24095208 | 24095208 | |
31077 | 31077 | 1916-03-25 | 8 | b-c | Guangdong news/ Long Jianzhang is under investigation. Long Jiguang in panic. Guangdong army on their way to expedite Yunnan.Servicemen in Guangdong required to make oath. | China | http://trove.nla.gov.au/newspaper/page/24095208 | 24095208 | |
31078 | 31078 | 1916-03-25 | 8 | c | Wing On & Company in Hong Kong raises more funds by floating shares and its notice, signed by Guo Le, Guo Quan, Yang Huiting, Du Zewen, Li Gen, Lin Zesheng, Li Yanxiang, Sun Zhixing, Yang Jinhua and others. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24095208 | 24095208 | |
31079 | 31079 | 1916-03-25 | 8 | c | Mails for pickup at the Tung Wah Times. Names listed. | http://trove.nla.gov.au/newspaper/page/24095208 | 24095208 |
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]);