This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30348 | 30348 | 1915-08-07 | 6 | a-c | China and Tibet are to sign a treaty on how Tibet is to be governed. | China | http://trove.nla.gov.au/newspaper/page/24094941 | 24094941 | |
30349 | 30349 | 1915-08-07 | 6 | b | News miscellany/Yuan Shikai awarded Japanese envoy for Sino-Japan negotiation and Japanese government awarded Lu Zhenqiang and Cao Yulin. Chinese government orders salt businessmen pay more tax in order to cope with financial crisis. Japanese people are not satisfied with Sino-Japan treaty and attack their government. Guangdong police commander Fei Sangzhi is moved to Sichun. Tan Xuehang proposes to build dams on Xijiang river to prevent floods. Lujun Detang proposes to carve Never Forget National Shame on spoons and knit on beddings. | China | http://trove.nla.gov.au/newspaper/page/24094941 | 24094941 | |
30350 | 30350 | 1915-08-07 | 6 | b | Huang Zhuoxing's poem. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24094941 | 24094941 |
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]);