This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25686 | 25686 | 1912-02-03 | 6 | a-b | Brief introductions about representatives of the republic of China for peace negotiation | Brief introduction about Wen Zhenrao, Wang Chonghui, Wang Zhaoming, Niu Yongjian, and Hu Ying, representatives on behalf of the Republic of China during Shanghai peace negotiation. | China | http://trove.nla.gov.au/newspaper/page/24092095 | 24092095 |
25687 | 25687 | 1912-02-03 | 6 | b-c | Guangdong, a world of robberies and killings | Widespread robberies, revenging killings, rapes,and other crimes in various places make Guangdong a horrifying world. | China | http://trove.nla.gov.au/newspaper/page/24092095 | 24092095 |
25688 | 25688 | 1912-02-03 | 6 | c | Censor in China | Statistics of Chinese people, foreign people in China. | China | http://trove.nla.gov.au/newspaper/page/24092095 | 24092095 |
25689 | 25689 | 1912-02-03 | 6 | c | Panic in Fentian | Revolutionaries in Fentian, northeast China, caused social instabilities there and Japan was asked to protect people there. | China | http://trove.nla.gov.au/newspaper/page/24092095 | 24092095 |
25690 | 25690 | 1912-02-03 | 6 | c | Important cable news | President Sun Yatsen askes permission for borrowing Guangdong railways' mortgage for northward expedition army. | China | http://trove.nla.gov.au/newspaper/page/24092095 | 24092095 |
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]);