This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28527 | 28527 | 1914-03-07 | 2 | c | Orders issued by the Chinese President Yuan Shikai on January 13 and 16 on legal and financial establishments. | China | http://trove.nla.gov.au/newspaper/page/24093030 | 24093030 | |
28541 | 28541 | 1914-03-07 | 3 | c | Former Chinese premier Zhao Bingjun dies suddenly. | Britain | http://trove.nla.gov.au/newspaper/page/24093029 | 24093029 | |
28542 | 28542 | 1914-03-07 | 3 | c | Bandits in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24093029 | 24093029 | |
28543 | 28543 | 1914-03-07 | 3 | c | Former American president William Taft suggests to intervene with the chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24093029 | 24093029 | |
28548 | 28548 | 1914-03-07 | 7 | c | Government troops in Henan province try to wipe out bandits. An association to be founded in Berlin to promote friendship and business between Germany and China. | http://trove.nla.gov.au/newspaper/page/24093033 | 24093033 | ||
28549 | 28549 | 1914-03-07 | 7 | c | King of Spain and his daily life. President of Mexico and his cruelty. An American couple decides to marry while in the church. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093033 | 24093033 | |
28550 | 28550 | 1914-03-07 | 7 | c | Tung Wah Times thanks readers who have paid their subscription fee. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093033 | 24093033 | |
28553 | 28553 | 1914-03-07 | 8 | c | The murder of Xia Cuifang, general manager of the Commercial Press (shang wu yin shu guan) in Shanghai, and comments by his wife. | China | http://trove.nla.gov.au/newspaper/page/24093036 | 24093036 |
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]);